how do I divide a line into several lines? Example: InputFile: name1, email3 name2, email3 name2, email3 OutputFile: name1, email1, name2 email2, name3, email3 How can I achieve this?? With a tMap I can change the ordering of the row, but I want to splitt the row into two new rows. Sorry for my english. Thank You very much.
Hello Lie,
thanks for your reply, but is it possible that you can describe your answer a little more detail?
In the tMapView I have on the left Site the rowdescribtion of the inputfile and on the right-Site are two output-Tables.
And what are next? I'm so sorry.
Thank you very much.
Balian
Hello Lie, the spliting of the row is completed. The result are two files like this: File1: name1, name2 File2: email1, email2 But how can i merge both files or is it posssible to merge the rows without creating of two tempfiles? Sorry for my english. I hope you understand me. 🙂 Best Regards!
Rather than sending the two tMap outputs to a file and then tUniting them, you can unite them directly in the tMap: when creating the second output within tMap just select the "Create join table from" option rather than the default "New output" option. There will then be only one flow out of the tMap but it will include the rows from both of the output tables within tMap.
