Skip to Content
0

How compare source Flat file data with target table

Mar 18, 2017 at 07:37 AM

69

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ravi kiran Pagidi Mar 21, 2017 at 07:21 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded