Issues - Pull Data From Table whose Source Is a Collection
I hope you will be able to help me with this one, I am having issues pulling data from a data table whose source is a collection.
I have a collection setup called "addSoftware" that contains a series of ID#s and a set of numbers called "Pressure Options"
I am successfully pulling this collection into a data table and performing some computations on the data using AddColumns. However, I am unable to use the LookUp command to pull a single value out of the table, even though I can pull data directly from the collection using LookUp. The forum is not allowing me to post screenshots just yet, so I have put some code snippets below. Any ideas?
This code pulls successfully from the collection and adds a few columns to a new table called "DataTable2"
This code pulls a value successfully from the collection
This code fails to pull data from "DataTable2" - regardless of whether it is a calculated column or not. I have tried something similar on data tables that aren't pulling directly from a collection and am having a similar issue.