Problem - you have following data as given below in a single row and you want to generate two rows out of this..
CountryName1 CountryCode1 CountryName2 CountryCode2
INDIA IND EGYPT EG
Solution - though there are many solutions, one quick solution incase you have requirement like above, where you know number of rows you want to split -
Take this row as input to tmap component and in tmap create one output group say out_1.
Now in this out_1 drag and link countryName1 and countryCode1 columns from input.
Now create another output group out_02 in this tmap and when "add a output" dialog comes
select "create join table from" and in the dropdown select out_1 group, so that our output rows from this out_02 group will also go to out_01 group. So our tmap will have only one output group out_01 containing rows from both out_01 and out_02. now in out_02 drag and link countryName2 and CountryCode2 columns.



CountryName1 CountryCode1 CountryName2 CountryCode2
INDIA IND EGYPT EG
Solution - though there are many solutions, one quick solution incase you have requirement like above, where you know number of rows you want to split -
Take this row as input to tmap component and in tmap create one output group say out_1.
Now in this out_1 drag and link countryName1 and countryCode1 columns from input.
Now create another output group out_02 in this tmap and when "add a output" dialog comes
select "create join table from" and in the dropdown select out_1 group, so that our output rows from this out_02 group will also go to out_01 group. So our tmap will have only one output group out_01 containing rows from both out_01 and out_02. now in out_02 drag and link countryName2 and CountryCode2 columns.
Really helpful, why didn't i read it this morning ! lol, thank you !
ReplyDeleteThanks, that's the easiest way I found and it's working perfectly.
ReplyDeletehi, thanks for sharing...keep it up
ReplyDelete