How to compare two data sources, column by column.

[Anonymous]

Hi 

I'm currently comparing two data sources using the tMap component.

One example is where I compare a .TXT file against a Sybase table by using the inner join in the tMap, to see the differences I set the tMap's output to Catch lookup inner join reject as "true" and this works quite well.

However since this is a join, as output I get a whole record(s) which doesn't appear in the main flow based on my keys and I'm more interested in pin pointing the actual column(s) that are incorrect. - I'm not sure if it's because of my tMap configurations, so attached are both the flow and tMap configurations.

Sybase table compared to .TXT filetMap editor configurations

If my question isn't clear here please let me know so I can clarify.

Thanks

[NMangaba_TAP]

Hi Rhall_2_0

Just trying to go through your solution and i was wondering if there's a chance you can provide some screenshots of how you configured the TMap component as your website has been currently down. 

Many Thanks, 

Naledi