Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have 3 variables and I want to combined them to 1 variable.
Please see below
What's the best way to do it?
Regards,
Vladimir
Or try a CROSSTABLE Load
CROSSTABLE (Choice, Value)
LOAD
Name,
Choice1, Choice2,Choice3
FROM YourTable;
What do you expect as result?
Have you considered concatenating the three fields
Choice1 & Choice2 & Choice3
I need to create list box, where I can see only aa, bb, cc and etc.
thanks,
Try like this
Result_Table:
LOAD Name,
Choice1 as Choice
Resident input;
Result_Table:
LOAD Name,
Choice2 as Choice
Resident input;
Result_Table:
LOAD Name,
Choice3 as Choice
Resident input;
Then drop orginal table.
Look on attached exmple.
Or try a CROSSTABLE Load
CROSSTABLE (Choice, Value)
LOAD
Name,
Choice1, Choice2,Choice3
FROM YourTable;