All,
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"
AddColumns(addSoftware,"multiplied",Pressure_x0020_Options*5, "prev ID", If(ID=1,0,ID-1))
This code pulls a value successfully from the collection
LookUp(addSoftware,ID=2,Pressure_x0020_Options)
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.
LookUp(DataTable2,ID=2,Pressure_x0020_Options)
Cheers and have a good weekend,
-Zac
Hi @Anonymous,
Can you please share the collection here? Seems to me that this should work as expected.
Regards,
Mona
Hey, sorry on the late reply to this. I cannot share the collection because it is proprietary data.
But - good news it magically started working after the latest update, who knows.
-zac
User | Count |
---|---|
185 | |
122 | |
91 | |
47 | |
42 |
User | Count |
---|---|
270 | |
158 | |
130 | |
84 | |
78 |