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?