Convert values from column to row

[pranit_somne]

Hi All,

I have data like below table,

ID	Business
15	Commercial Banking,Global Function-Risk (including Compliance),Retail Banking and Wealth Management
26	Commercial Banking,Retail Banking and Wealth Management
43	Global Banking and Markets,Global Functions
46	Global Banking and Markets
49	Global Banking and Markets

I want to convert it into below data,

ID	Business
15	Commercial Banking
15	Global Function-Risk (including Compliance)
15	Retail Banking and Wealth Management
26	Commercial Banking
26	Retail Banking and Wealth Management
43	Global Banking and Markets
43	Global Functions
46	Global Banking and Markets
49	Global Banking and Markets

Can anyone please help.

[jpenuliar]

You can use qlik function Subfield to achieve your requirement.

link: https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunc...

[jonathandienst]

Yup - the 2 parameter version of SubField():

LOAD ID,
SubField(Business, ',') as Business
FROM ....