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

[tejasp47]

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

[rubenmarin]

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))