using two field in a same custom function

[Former Member]

hi experts,

i have a query

suppose i have a data of 3 field

Name State city

tom gujrat varoda

billy rajasthan jaipur

jeny maharastra mumbai

jeny maharastra pune

now i want to change the city to "navi mumbai" where ever i find state = 'maharastra' i.e.

Name State city

tom gujrat varoda

billy rajasthan jaipur

jeny maharastra navi mumbai

jeny maharastra navi mumbai

thnks

[Former Member · Accepted solution]

Use this in the mapping tab of City

ifthenelse(Table.State='maharashtra','navi mumbai',Table.City)

For Table.State and Table.City, "Table" is the name of your source. You can just drag and drop them from the input schema.

Remember to maintain the spelling of the comparison string exactly as it is like in the source data.

Regards,

Suneer

[Former Member · Accepted solution]

thnx suneer