Hi, I have several shemas with two columns, one columns is the id, the other one is the information concerned to the id. Now, I want to combine these shemas as one shema with one column of id and other columns with information concerned. How can I do? Thank you!
Hello, I would do it this way: - Use three tFileInputDelimited (one for each file), define the schemas as "ID" and "INFO" - Use a tMap and connect it with all file inputs. Set up the schema and expressions like in the screenshot below I hope this was helpful for you. Regards, Theo Edit: The expressions looking like ro... in the screenshot are row1.ID, row1.INFO, row2.INFO and row3.INFO