Skip to Content
avatar image
Former Member

How compare source Flat file data with target table

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 21, 2017 at 07:21 AM

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

    Add comment
    10|10000 characters needed characters exceeded