How to setup Coalesce field in robust transform map?

[Ravi Gupta1]

Hi,

I want to insert/update record from Staging table of robust transform map to two target table.

I have two target table: tableA and tableB.

To update the record in tableA, I have fieldA in staging table.

To update the record in tableB, I have fieldB in staging table.

I wan to create two coalesce field in staging table which can update record of two different table.

Please assist.

Thanks

Ravi

[jtshone]

Hi did you manage to find anything out about this?

[Sumanth16]

Hi @Ravi Gupta1 ,

Use Unique Input Sets as coalesce in Robust Transform.

If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!

Thanks & Regards,

Sumanth Meda