Data separation

[qlikview979]

Hi Experts,

i have one column data like this

Name

ComprehensivePolicy,NCB Protect Cover,Zero Dep Cover,Invoice Cover,Engine Protect,Electronic Circuit Cover,Passenger Cover,Quick Assistance Cover

i need like

Name

ComprehensivePolicy,

NCB Protect Cover

Dep Cover

Invoice Cover

Engine Protect

Electronic Circuit Cover

Passenger Cover,

Quick Assistance Cover

[tresesco · Accepted solution]

Try using subfield() like:

Load

          SubField(Name, ',') as NewName

From <>;

[MindaugasBacius]

Subfield() might help you.

[Anonymous]

Hi

Have a look. Hope it will help