In CIDS How do you MERGE 2 INPUT files into 1 OUTPUT File

[micbur250]

I have 2 files created from SAP tables, MARD and MSKA, that have the same format. I need to MERGE these to files into 1 combined file. INPUT1 has 10 records...INPUT2 has 15...my OUTPUT needs to contain 25 records. Is easy to do in Data Services with the MERGE Transform but in CIDS I see no way.

[Kumar_Shubham]

1. Create a field "Join_Field_1" in first table MARD and hardcode the value as '1'.

2. Create a field "Join_Field_2" in second table MSKA and hardcode the value as '2'.

3. Bring Row generation transform and provide the value as '1' in Row number starts at and '2' in Row count.

4. Join all 3 in one single transform.

5. Keep Row generation transform as a left table and perform left join with first table "MARD" and in the same transform again do left join with second table.

Bring all the fields from both the tables in the output. This will cause duplicate fields in the output.

6. And in the next transform to avoid duplicate fields do the concatenation of varchar fields and sum of decimal/int fields.

7. This way you will achieve the merge.

Thanks

Shubham