Regarding data source

[Charani]

how to do the location hierarchy in cmn_location when i try to import through the data source,suppose first comes the region called Apac,India,maharastara,pune,area,building,flatno4,when i try to import through data source it should check the whether the field is there are not so in the same way it should check all the fields,if field is not there create a new field,then suggest me with the best possible solution,i have been trying with the on before transform script.

[Sulabh Garg]

Hi Charani,

you can use choice action as "Create" to create new record if not exist else map with the existing record.

Choice action

Specifies the action to take if the import set contains a reference or choice value other than those available. Appears if the target field is a choice list or reference field. 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.

[Charani]

Could you please ellaborate it for me to better understanding