How compare source Flat file data with target table

[Former Member]

Hi experts,

I want to compare my source data with target table filed by filed by row wise.

Source Data Col1 Col2 Col3 27 Air via Changi Airport PTB 3 Air 28 Sea via Marina Bay Cruise Terminal Singapore Sea 29 Sea via Marina South Pier Sea 30 Sea via SHIPPING Sea Target Data Col1 Col2 Col3 27 Air via Changi Air 28 Sea via Marina Bay Cruise Terminal Singapore Land 29 Sea via Marina South Pier Sea 30 Sea via SHIPP Air

My results Would be

Final Col1 Col2 Col3 Error 27 Air via Changi Airport PTB 3 Air Col2 28 Sea via Marina Bay Cruise Terminal Singapore Sea Col3 29 Sea via Marina South Pier Sea 30 Sea via SHIPPING Sea Col2,Col3

Can any one suggest using BODS

[former_member208402]

You data is not clear. Could you please post data in table format