Implementing text to column feature in Qlik Sense

[She1]

Hi,

I want the text values in  a comma separated text field to be split into multiple fields with one value each .The field is as shown below. I want the values in separate columns.

[Lisa_P]

The Subfield function can do that either in the load script or in the chart itself ..

See instructions in Qlik help ..

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunction... 

[sidhiq91 · Accepted solution]

@She1  Please use the below script, to get the desired output.

NoConcatenate
Text:
Load * Inline [
Text
Microsoft Google IBM SalesForce Alteryx aws gcp RPA
];

NoConcatenate
Text1:
Load *,
SubField(Text,' ',1) as Text1,
SubField(Text,' ',2) as Text2,
SubField(Text,' ',3) as Text3,
SubField(Text,' ',4) as Text4,
SubField(Text,' ',5) as Text5,
SubField(Text,' ',6) as Text6,
SubField(Text,' ',7) as Text7,
SubField(Text,' ',8) as Text8
Resident Text;

Drop table Text;

Exit Script;

If this resolves your issue please like and accept it as a solution.

[She1]

Thanks Lisa! My issue will get resolved with this function!

[She1]

Thank you so much! Subfield suffices my purpose! 

[Sloane]

is there a way to achieve this split (to columns and not rows) without writing out as many Subfield commands?

[Lisa_P]

If they are all comma separated, all you need to do is :

SubField(Text, ',') as Partners

This should separate them all out