Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikview979
Specialist
Specialist

Data separation

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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try using subfield() like:

Load

          SubField(Name, ',') as NewName

From <>;

View solution in original post

3 Replies
tresesco
MVP
MVP

Try using subfield() like:

Load

          SubField(Name, ',') as NewName

From <>;

View solution in original post

MindaugasBacius
Partner
Partner

Subfield() might help you.

qlikviewnovice
Specialist II
Specialist II

Hi

Have a look. Hope it will help