The Definitive Guide to Data Quality
Some Rows are comments that are just one big string and some Columns also contain comments.
I wanna connect those 2 CSV Files with tMap and output one combined CSV File
what kind of 'combination' ? are you doing some mapping, join filter. ?
Do you need all the data to be in the tMap ?
First thing, it's to manage Only the data you need => filter, extract data to keep the right ones.
i'm filtering Data in the tMap, seems to be a bad idea