tLogRow ok, tFileOutputExcell IllegalArgumentException: Invalid row number (1048577)

[Skywalker1]

Task description: merging five (5) tables; 1st (ID, PRODUCT_NAME) 5438 rows, 2nd to 4th 14 colums (ID, PRODUCT_NAME, MONTHLY_SALE_JAN - DEC). Table 2 to 4 are 14 columns, each 4.5-5k rows. Expected outcome 50 columns, 5438 rows. System (Talend Studio) behaviour: tLogRow runs without errors, but continously (?!).  tFileOutputExcell reaches 1.048.576  and reports error - maximum file size exceeded (number of rows exceeded). Please have a look at attached screenshots. Anybody encountered similar situation? Any hints how to achieve expected  results? Kind regards, S. Ps. Posting at the right place now (not Sandbox but MySQL) and explaining the issue more clearly.

[manodwhb]

Check the below solution.
https://community.talend.com/t5/Design-and-Development/IllegalArgumentException-Invalid-row-number-o...

[Skywalker1]

tMap node wrongly specified produced Cartesian product :-0 😉

[manodwhb]

@Skywalker , yes, if you have not configured tmap for join you will find Cartesian product .