Avatar

Correct answer by
Employee Advisor

Hi @AC_Dev 

You can achieve the fixed list at the Load Activity level.

Edit the format 

Denis_Bozonnet_0-1657699308924.png

 

Select the field you want to format and click on the Detail magnifying icon

Denis_Bozonnet_1-1657699374094.png

 

In the Details, use the Remapping section to fill in the expected values from the value in the file to the expected value in the data schema

You would have to set error to use a default value in case of error

Denis_Bozonnet_3-1657699541522.png

 

Hope this helps,

Thanks

Denis

View solution in original post