Solved: help me - Qlik Community

Report Inappropriate Content · ‎2014-04-10

can anybody help me out in solving this?

input table is

	Name
1	A,B,C
2	D
3	E,F

i want output as

ID	name
1	A
1	B
1	C
2	D
3	E
3	F

Colin-Albert · ‎2014-04-10

Use the subfield() function for the Name data

load

ID,

subfield(Name, ',') as Name

....

View solution in original post

Colin-Albert · ‎2014-04-10

Use the subfield() function for the Name data

load

ID,

subfield(Name, ',') as Name

....

MK_QSL · ‎2014-04-10

Load

ID,

Subfield(Name,',') as name

From FileName;

PrashantSangle · ‎2014-04-10

Hi,

Please this discussion.

Problem with field

http://community.qlik.com/message/479696

It have lots of solution as per your requirements,

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

help me

Related Topics