Dataflow - Lookup fields

(0) Share

Report

Posted on by kelly1

193

Hi,

We want to create a number of dataflows. Each dataflow loads data from an sql table and they also have some lookup fields. I have read that to be able to map lookup fields you need to create a key. Once I created the key on the lookup table the flow worked fine.

However I want to create a dataflow which also loads data into the lookup table. This is resulting in an error since it violates the key. When the dataflow is running it creates duplicate records and then deletes them at the end so the process itself is violating the key.

Is there a way to get this to work please?

THanks