pick and match function

[eduardoheres]

Hi all,

one question im in the data load editor and im trying to use the pick and match funtion as i use in the the sript but when i try to load it it put that the $Field is not found can you help me to put it right

script

pick(match($Field,'Country','SUB REGION','REGION','ENTITY','CONSOLIDATED','Country2'),Country,[SUB REGION],REGION,ENTITY,CONSOLIDATED)

in the data load editor im puting the same formula and i get it wrong

Thank you

[CELAMBARASAN]

$Field is a metadata field which will get created at the final stage of the script execution (while saving the app after reloading the data).

What is the use case/scenario in the script for this field, may be there might be a different ways to do that which can be suggested by many people here in the community.