Can any one please help me on below requirement.
I have field with below data in excel. Please help me to replace Not Applicable to n/a in the backend.
Thanks in advance
When u load it, load it as follow:
if(Number='Not Applicable','n/a', Number) as Number
load *, if(Number='Not Applicable','N/A',Number) as New;
load * Inline[
Retrieving data ...