Choice action from transform map does not ignore the empty fields record.

[Ashwini Jadhao]

Hi,

I am importing the data from London instance to madrid instance by  using transform map.

Issue is Table contains Status as a string field with choices.But, the choices are different on both instances.

and the condition is If the choices are different then we need to ignore that field.

For status field I had used Choice action as ignore and when I run the transform it will create all the records with field value as Pending (pending is the first choice from the choice list).

How to do this please help.

Thank you

[Dubz · Accepted solution]

Is there a default value configured on the field on your Madrid instance? It might be correctly ignoring the field in the transform but applying the value via some other means, either default value or business rule.

[Ashwini Jadhao]

yes There is a default value .

thank you.

One more query I have

When the records get created and if the user is not present on the user table then it takes my name for that record.

also for the opened_by field I use choice action as ignore

[Dubz]

I believe the opened_by field must have a value when records are inserted. If it ignores the value from the import it will take the currently logged in user (you). If you need it to use a different default value you will need to add rules to the table to work on insert or use a script on the field mapping.

[Ashutosh Munot1]

Hi,

Also check Dictionary override for that field if you dont find anything in default value, just an addition to David's answer.

Thanks,
Ashutosh