Comparing csv files with more no. of columns

Anonymous — Fri, 12 Feb 2016 13:32:50 GMT

Hi,
I have two csv files to compare in talend DI and both files have around 40 columns. Currently, I am mapping the columns one by one between the files in tMap for comparing which I think is cumbersome. Please if anybody has idea how to map the columns without doing it one by one.

Thanks in advance.

Re: Comparing csv files with more no. of columns

Anonymous — Fri, 12 Feb 2016 15:21:28 GMT

What exactly are you comparing and why? There are ways to make comparisons and mappings less tedious, but you have to consider the tool to be "dumb". It is not going to know what you want and the most you will get out of mapping functionality is for it to automatically columns that are named the same.....and that is as it should be.

If you take a screenshot of your current mapping (I am assuming you are using a tMap) with some explanation as to why and what you want to achieve, we may be able to suggest better ways of doing this.

topic Comparing csv files with more no. of columns in Installing and Upgrading

Comparing csv files with more no. of columns

Re: Comparing csv files with more no. of columns