How to get value in another field

[bsbernabe]

Hello There,

How to get value in another field?

I try this : if(([Sub_Value]), 'Migrated', [Sub file]) 

Sub_Value	Sub_file	output	Should be
General office clerks	NONE	NONE	General office clerks
Migrated	SARI SARI STORE	SARI SARI STORE	SARI SARI STORE
Migrated	FARM CORN FIELD	FARM CORN FIELD	FARM CORN FIELD
Migrated	FARMING	FARMING	FARMING
Migrated	FISH VENDOR	FISH VENDOR	FISH VENDOR
Migrated	RUBBER PLANTATION	RUBBER PLANTATION	RUBBER PLANTATION
Migrated	RUBBER PLANTATION	RUBBER PLANTATION	RUBBER PLANTATION
Migrated	FARMING	FARMING	FARMING
Migrated	MAGSAYO STORE	MAGSAYO STORE	MAGSAYO STORE
Car, taxi and van drivers	-	-	Car, taxi and van drivers
Other field crop farmers	-	-	Other field crop farmers

Best Regards,

Bing

[Vegar · Accepted solution]

Sub_Value	Sub_file	output	Should be
General office clerks	NONE	NONE	General office clerks
Migrated	SARI SARI STORE	SARI SARI STORE	SARI SARI STORE
Migrated	FARM CORN FIELD	FARM CORN FIELD	FARM CORN FIELD
Migrated	FARMING	FARMING	FARMING
Migrated	FISH VENDOR	FISH VENDOR	FISH VENDOR
Migrated	RUBBER PLANTATION	RUBBER PLANTATION	RUBBER PLANTATION
Migrated	RUBBER PLANTATION	RUBBER PLANTATION	RUBBER PLANTATION
Migrated	FARMING	FARMING	FARMING
Migrated	MAGSAYO STORE	MAGSAYO STORE	MAGSAYO STORE
Car, taxi and van drivers	-	-	Car, taxi and van drivers
Other field crop farmers	-	-	Other field crop farmers

Try this expression:

if([Sub_Value]='Migrated',
   [Sub_file],
   [Sub_Value]
   )  as output

[bsbernabe]

Thank You so much its working so great...