Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have some data. I need to create field 'Home Away' based on 'Ground' Field .
if Ground out of India it will be Away otherwise Home in script.
Ground | Home Away |
Melbourne | Away |
Manchester | Away |
Lord's | Away |
Bengaluru | Home |
Delhi | Home |
Please any one help me.
Hi,
it is better to have/create a field "country" where you can found the Country related to each Ground, like this
Ground | Country
Melbourne | Australia
Manchester | England
Bengaluru I India
Delhi I India
then you can do this: If(Country<>'India','Away','Home')
otherwise if you don't have such column, you should hardcod it on the script..