Solved: Modify the data in data load editor as per my requ... - Qlik Community

sivakrishna · ‎2019-04-12

I have data table like this

Team:
Load * Inline
[ Id, Teama,Teamb,WON
1,CSK,KKR,CSK
2,SRH,CSK,SRH
3,KKR,SRH,SRH

];

I want help to convert above data like below table how to do

Id,Team,Won
1,CSK,CSK
1,KKR,CSK
2,CSK,SRH
2,SRH,SRH
3,KKR,SRH
3,SRH,SRH];

PrashantSangle · ‎2019-04-12

Try like

Load Id,Teama as Team, Won From TableName;
Concatenate
Load Id,Team=b as Team, Won From TableName;

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 🙂

View solution in original post

PrashantSangle · ‎2019-04-12

Try like

Load Id,Teama as Team, Won From TableName;
Concatenate
Load Id,Team=b as Team, Won From TableName;

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 🙂

sivakrishna · ‎2019-04-14

Thanks a lot for your response.

Modify the data in data load editor as per my requirement