Data Cleaning

[dsharmaqv]

ID	Business line
1	Retail Banking,Privet Banking,Whole Sale
2	Retail Banking(RB);Privet Banking(PB),Whole Sale
3	Retail Banking(RB);Privet Banking(PB);Whole Sale

Output

ID	Business Line
1	Retail Banking
1	Privet Banking
1	Whole Sale
2	Retail Banking
2	Privet Banking
2	Whole Sale
3	Retail Banking
3	Privet Banking
3	Whole Sale

Can some one help me achiving the out put

I tried with subfield function but subfield is not able to remove ','

[MK_QSL]

Load

     ID,

     SubField([Business line],',') as [Business Line]

From TableName;

[dsharmaqv]

can I have the sample app please

[MK_QSL]

//Load this in your QVW and run the script.

Data:

LOAD ID,

     SubField(Replace([Business line],';',','),',') as [Business Line]

FROM

[https://community.qlik.com/thread/246434]

(html, codepage is 1252, embedded labels, table is @1);

[stabben23]

You need to replace first, then use subfield.

Temp:
Load *,
subfield(BussinesLine1,',') as BussinesLine2
;
LOAD *,
Replace(BussinesLine,';',',') as BussinesLine1
;
LOAd * inline [
Id, BussinesLine
1, "Retail Banking,Privet Banking,Whole Sale"
2, "Retail Banking(RB);Privet Banking(PB),Whole Sale"
3, "Retail Banking(RB);Privet Banking(PB);Whole Sale"
];

[stabben23]

more elegant solution, use this.