Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
TeodoraBurlica
Partner - Contributor III
Partner - Contributor III

Sorting in script

Hello,

I have this table: 

TeodoraBurlica_0-1680191007805.png

 

I have Column 1 and Column 2 and I want to get Column3. How should I write the script?

Thanks

 

Labels (1)
2 Replies
MarcoWedel

I guess without any additional specification this should be a solution, right?

 

MarcoWedel_0-1680209334916.png

 

 

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
];

 

 

TeodoraBurlica
Partner - Contributor III
Partner - Contributor III
Author

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.