Hello-
How do you transpose columns inside the Data Model using eval?
My goal is to filter a column called column1 inorder to extract data from a second column called column2. A third column would be created to only hold vales transferred from the second column. The name of this column would be column3.
column1
filter1
filter2
filter3
column2
data1
data2
data3
column3
null
data2
null
This code pulls the value randomly:
|eval if(like(column1,"filter2"),column2,NULL)
Field Name = column3
I need to extract the value from column2 using the same row referenced in column1.
Thanks!
... View more