Scinario Based interview Question .....

 How To Achieve The Scenario.

Input

File1.csv 

id,Name

1,Mahendra

File2.csv

City, State

Hyd,Telangana

File3.csv

Stateid

Ts

I want Out put

File.Csv

Id,Name,City,State,StateId

1,Mahendra,Hyd,telangana,Ts

Solution:-

[tFileInputDelimited (File1)] --> [tAddRowNumber] -->|

                                                      |

[tFileInputDelimited (File2)] --> [tAddRowNumber] -->|--> [tMap] --> [tFileOutputDelimited (File.csv)]

                                                      |

[tFileInputDelimited (File3)] --> [tAddRowNumber] -->|