Duplicate rows based in ocurrences in a field

Meallly · ‎2024-04-16

Hello

I have a table of questions and answers from an account.
Some questions are multi choice and I would like to have a line for each of them.

For example:
QUESTION ID, ANSWER
1, Yes
2, No
3, 1^5^10

For question 3, it is a multi-choice question where the user has selected 3 answers.

I would like to obtain the following final table:

QUESTION ID, ANSWER
1, Yes
2, No
3, 1
3, 5
3, 10

How could I get it?

Lisa_P · ‎2024-04-16

You could do this in the load script:

Data:
Load *,
Subfield(ANSWER, '^') as NEWANSWER;
Load * Inline [
QUESTION ID, ANSWER
1, Yes
2, No
3, 1^5^10
];

It would result in this in the data load:

Meallly · ‎2024-04-17

It works! Thank you so much!!