This content has been marked as final. Show 3 replies
Dual can sometimes be a little tricky.
Instead of doing the conversion of the number to text inside dual, do something like this:
EMP1: load *, // Dual made from a text field instead of the conversion of number to text directly dual(_txtProfile,profile) as xxxx; LOAD customer, profile, text(profile) as _txtProfile, priority; LOAD * inline [ customer|profile|priority 14368|41214|6 14368|9055|1 14368|41214|3 14109|41214|6 14109|41480|1 14109|41370|2 13339|9055|7 4633|19018|7 ] (delimiter is '|');
This gets me the right values, like below: