Trying to merge multiple spreadsheets into one

Anonymous — Fri, 26 Jul 2019 00:35:35 GMT

I have 4 spreadsheet files. One is a list of products and prices. The other 3 are warehouse inventory lists. The inventory lists all have the same schema except one column which is the name of the warehouse with a boolean to indicate it is in stock. I am basically trying to combine these spreadsheets into one. Just combining two of the warehouse lists is proving difficult as I don't seem to be getting the right numbers. If I many copy and paste the spreadsheet into a new spreadsheet and use Excel to remove duplicates based on productid, I get a different amount of rows than when trying to use tMap and following the tutorials. I'm not sure what I am doing wrong or what the best way to do this is.

Re: Trying to merge multiple spreadsheets into one

Anonymous — Fri, 26 Jul 2019 09:59:36 GMT

Hello,

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

topic Trying to merge multiple spreadsheets into one in Talend Studio

Trying to merge multiple spreadsheets into one

Re: Trying to merge multiple spreadsheets into one