a \n delimited value into Multiple rows in Qlik-sense

tejasp47 — Fri, 22 Oct 2021 04:15:33 GMT

I have a requirement to split the records in a specific format.

I have attached the screenshot of input fields and expected output field. I have tried using subfield, iterno, etc. at the time of load script, but no luck..

Can anyone help me understand if it's possible in Qlik-Sense and if yes, how?

Thank you.

Input -

Record	Field
1	AAA BBB CCC
2	AAA BBB CCC
3	AAA BBB CCC DDD EEE
4	AAA BBB CCC DDD EEE FFF GGG HHH

Output -

Record	Field
1	AAA
1	BBB
1	CCC
2	AAA
2	BBB
2	CCC
3	AAA
3	BBB
3	CCC
3	DDD
3	EEE
4	AAA
4	BBB
4	CCC
4	DDD
4	EEE
4	FFF
4	GGG
4	HHH

Re: a \n delimited value into Multiple rows in Qlik-sense

rubenmarin — Sat, 23 Oct 2021 07:55:26 GMT

Hi, subfield would do the trick, but you need to capture with character is being used as line separator. can you try? Subfield(Field, chr(10))

topic a \n delimited value into Multiple rows in Qlik-sense in App Development

a \n delimited value into Multiple rows in Qlik-sense

Re: a \n delimited value into Multiple rows in Qlik-sense