I’ve got a dynamic property dataset. It has multiple columns and I need to query against this using the Lookup expression. Problem is, the criteria involves values from 2 of the columns, anyway to do this easily?
You should be able to use other functions like concat (string concatenation) within your lookup expression.
I do not understand how I could you the concat function. here is what my dataset looks like:
I want to return the value in column “Text”, but i want to lookup the number 2012 in column “y” and the number 4 in column “m”
how do i incorporate column “m” in the above code?
You can’t do that with the lookup function right now. However, you can add an additional column to the dataset (if it is a SQL query) called ym which is a concatentation of the year and month columns. In MySQL you can do the following:
SELECT CONCAT(year, month)
ok, i can do that. it sounded like it could be done on the ignition side.