Skip to Content
Jan 25, 2022 at 03:15 PM

Data Warehouse Cloud data flow - Check target table for duplicate entries

631 Views Last edit Jan 26, 2022 at 01:41 PM 2 rev

Hello experts,

currently we are trying to insert data into a table via DWC data flow. Now we want to prevent that the data flow creates duplicate entries in the target table. Problem is that the field we have to check is NOT a primary key.

EDIT: The primary key UUID is also used saved on other tables ad referenced via association.

The db table itself has a UUID as primary key and a second data field "example" for a string 100. We need to check if there is already a entry in the table (e.g. "Foobar" in data field "example").

Which approach would you recommend inside the data flow?