Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
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.
Number
4586
12463
28336
Not Applicable
536303
Thanks in advance
When u load it, load it as follow:
if(Number='Not Applicable','n/a', Number) as Number
When u load it, load it as follow:
if(Number='Not Applicable','n/a', Number) as Number
try this
load *, if(Number='Not Applicable','N/A',Number) as New;
load * Inline[
Number
4586
12463
28336
Not Applicable
536303
];