Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

sivakrishna
New Contributor

Modify the data in data load editor as per my requirement

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];

1 Solution

Accepted Solutions

Re: Modify the data in data load editor as per my requirement

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.

View solution in original post

2 Replies

Re: Modify the data in data load editor as per my requirement

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.

View solution in original post

sivakrishna
New Contributor

Re: Modify the data in data load editor as per my requirement

Thanks a lot for your response.