Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
I am bored of writing IF statement to replace data with dummy data, please suggest me the quickest way, following is example of what I wanna achieve.
CurrentFeild ResultFeild
James Apple
John Banana
Sarah Avpcado
... ....
Create a mapping table (load from inline or from Excel) and use ApplyMap to replace the current field with the result.
Create a mapping table (load from inline or from Excel) and use ApplyMap to replace the current field with the result.
Applymap is the better option.
See this post for more details Don't join - use Applymap instead
Hi Guruprem,
You can also make use of a Lookup() function.
Thanks,
Sangram.