how to split the values in excel with more functions

[Anonymous]

Hi,Experts.

My extracted table data having more functions in one excel cell.I want split the values into different rows. Iam attached a table.

In my data one of the column is Group.The Group column is one of the sheet(i,e.LH  Driver Safety Scorecard) of attached data.please give me a suggestion.

Thanks in advance.

[Quy_Nguyen · Accepted solution]

Try this function:

https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Scripting/StringFunctions/SubFiel...

Example:

Load *, SubField(Group,'___') as NewField;

LOAD * INLINE

[

Group

NYALA___TC-993684___PC-ZM10000, NYALA EMAIL

]

[Anonymous]

Hi,Quy Nguyen.Thank you giving good suggestion.

IAm using same expression. Its possible only one row value to splitting purpose.When i execute the data is  combining with ',' & '__'.So i want split hole data of group column and the data  spit & the split data should be separate row.So please give another suggestion.

Thanks.

[Quy_Nguyen]

Hi,

Just replace the ',' by '___'

Load *, RowNo(), SubField(Replace(Group,',','___'),'___') as NewField;

LOAD * INLINE

[

Group

'NYALA___TC-993684___PC-ZM10000, NYALA EMAIL'

'SATWANT___TC-944083___PC-ZM10000, SATWANT EMAIL'

'STALLION MOTORS___TC-943658___PC-ZM10010'

'TOOL OF TRADE'

];

[Anonymous]

Its working.

Thanks for give good suggestion.

[Quy_Nguyen]

Glad it helped. If your question has been answered with your satisfaction, please mark the appropriate  reply as correct/helpful.