How to use coalesce and choice action combination in Table Transform Map

[Dushan]

I'm creating a transform map to upload data to a target table through a staging table via an excel sheet upload: 
there I have two 'target field'(S) called  client id and client name .
What I want to clarify is if we set both coalesce to true and choice action to create what is the effect?
Do we want to specify both field values ( none of the fields are a reference field) 
What happens if we keep coalesce to true and choice action to ignore

[Priyanka Vasant · Accepted solution]

Hi,

This field is available if the target field is a choice list or reference field. This field specifies what to do if the import set contains a reference or choice value other than those available. Select one of these options:

• create: Create a new choice or record in the reference table.
• ignore: Ignore the new value from the source table.
• reject: Skip the entire row (record) containing the new value and continue to the next row.