Thank you, I think there is a mistake later in the script - maybe it is somehow connected with the dual nature of the status field?
Concatenate(Main_table) //table loaded earlier
text(status) as status_noorder,
Left Join (Main_table) // here i want to replace status_noorder with the status from the first table
DROP TABLE [Funnel2_order];
Drop Field status_noorder From Main_table;
still struggling with Dual:
dual(status,ApplyMap('Funnel2_order',status)) as status, // option1
ApplyMap('Funnel2_order',status) as status // option 2
Neither of above options work. The result is just the plain text 'status' field.
Please, correct me if i am wrong: in my case applymap finds the Funnel2_order table, takes the first column funnel_status, maps it with the status field from my second load and returns the second column step (number). Is that correct?