topic Re: Duplicate rows based in ocurrences in a field in App Development

Duplicate rows based in ocurrences in a field

Meallly — Tue, 16 Apr 2024 16:00:08 GMT

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 — Tue, 16 Apr 2024 23:07:49 GMT

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 — Wed, 17 Apr 2024 14:23:50 GMT

It works! Thank you so much!!