Update the field

[Anonymous]

Hi experts,

I am having one table with 6 fields including applymap.

So now my question is want to update the applymap field with conditions.

Can you please help me on the same..

Thanks in advance...

[YoussefBelloum]

Hi,

what is the condition you want to apply with the applymap ?

Please try to explain in detail what you want to do

[clondono]

Can you share a sample of your data?

Maybe something like this will work for you:

// Load mapping table of your fields:

map1:

mapping LOAD *

Inline [

Field1, Field2

Xx, YYYY      //X and Y is your data

Xxx, Yyyy

] ;

map2:

mapping LOAD *

Inline [

Field1, Field2

Xx, YYYY      //X and Y is your data

Xxx, Yyyy

] ;

// Load list dimensions

YourTableName:

LOAD *,

If(Your first condition here,

          ApplyMap('map1', Xx,'What to replace with'),

               Your second condition here,

                    (ApplyMap('map2', Xx,'What to replace with'))) As YourFieldName ;

[Anonymous]

Thanks for the reply

Let us assume that i have one applymap field called name

now i need to update the name field to apple

now my condition is if (name ='mango' and product ='hai' ) THEN 'mangonew' else name

Can you please tell me  niow?

[YoussefBelloum]

as soon as you want to put a condition on the field name, you will have different fields (with different names), here you will have 2 different field (appe, mangonew)

Try this:

if(match(name,'mango') and match(product,'hai'),  ApplyMap('mapping_table_name', ...,'...')) As apple,

if(not match(name,'mango') and not match(product,'hai'),  ApplyMap('mapping_table_name', ...,'...')) As mangonew