Combine from 3 variable to 1

[Anonymous]

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

[swuehl]

What do you expect as result?

Have you considered concatenating the three fields

Choice1 & Choice2 & Choice3

[Anonymous]

I need to create list box, where I can see only aa, bb, cc and etc.

thanks,

[Anonymous]

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.

[Anonymous]

Look on attached exmple.

[swuehl · Accepted solution]

Or try a CROSSTABLE Load

CROSSTABLE (Choice, Value)

LOAD

     Name,

Choice1, Choice2,Choice3

FROM YourTable;