transform map which better Ignore or skip

[naji nabulsi]

Hello all,

I have a question about field map .

 

when the source field is a reference which best choice action [ ignore ] or [ skip ] and which one of them throw error
thanks in advance

[Abhijit4 · Accepted solution]

Hi @naji nabulsi 

It actually depends on your case, here is the explanation what is mean by ignore and reject options:

• ignore: Ignore the new value from the source table ( still new record will be processed ).
• reject: Skip the entire row (record) containing the new value and continue to the next row.

So, if you are not supposed to insert entry into target table with invalid/empty reference field value then use reject option. If you think, records can be processed with invalid reference values as well then you can use 'ignore' as it will create new entry in target table but it will not populate reference field value.

[Ankur Bawiskar]

@naji nabulsi 

It's well explained in docs

sharing few links which you can go through as well

Set choice action for reference field imports 

Choice action field for Field Map record in Transform Maps 

If my response helped please mark it correct and close the thread so that it benefits future readers.