Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have this table:
I have Column 1 and Column 2 and I want to get Column3. How should I write the script?
Thanks
I guess without any additional specification this should be a solution, right?
table1:
LOAD *,
If(Match(RecNo(),2,3,7),'ok') as Column3
Inline [
Column1, Column2
11,15
12,11
13,12
14,14
15,16
16,17
17,13
];
This shouldn't be hardcoded. First look for the first value (minimum = 11), if it finds it put ok, then, go to the next, 12, and so on. Order is very important.