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

Modify the data in data load editor as per my requirement

sivakrishna — Fri, 12 Apr 2019 12:06:06 GMT

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 — Fri, 12 Apr 2019 12:09:37 GMT

Try like

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

Regards,

sivakrishna — Sun, 14 Apr 2019 16:41:42 GMT

Thanks a lot for your response.