Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thank You so much its working so great...