Add internally maintained operation codes to a table

[former_member298052]

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

Andrzej

[former_member187605 · Accepted solution]

You can do this with a single Map_Operation transform after the Table_Comparison. And a single output table with an extra column. With following settings:

[former_member298052]

Thanks, very helfpul!