Skip to Content
Dec 03, 2018 at 09:04 AM

Add internally maintained operation codes to a table


Hello There,

I'm currently trying to display the operation codes, which are internally maintained during the table comparison transformation. The solution I would use right now is this:

  • 1. Take a source file and use a Table comparison to create operation codes (At that point they are only displayed internally).
  • 2. Use a Map Operation Transform to populate tables with just one operation code each table.

You will now have 4 tables, one for every category.

  • 3. Use a query Transform to add a operation code column to each table and populate it by hardcoding. Meaning: All rows in the insert table to ‘Insert’, all in the update table to ‘update’ and so on.
  • 4. Now you have 4 tables with operation codes. The only thing left to do is make one table out of this four by using the merge transformation.

I feel like this is a very unefficient way to do this and would be very happy if one of you could provide a more elegant solution.

Best regards