regarding applymap function

[dineshkumar]

while using apply map function, the machine throws a statement called "MAPPING requires 2-column input". so, when using applymap, is the mapping table have to contain only two column? and i am using database where it has many column what is the best practice for this issue??

[datanibbler · Accepted solution]

Hi Dinesh,

exactly! The Applymap() function does require a mapping_table that must not have more than two columns - the left  column is what you pass to the function and the right column is what it returns, so the order cannot be changed.

If you want to map something coming from a table with more columns, you'll have to load resident from this only the two columns that you need for the function.

HTH

Best regards,

DataNibbler

[teiswamsler]

hi Dinesh Kumar

I think u can find your answar in this tread.

quick applymap example

/Teis

[gautik92]

mapping table should have oly two columns

have a look at this

quick applymap example

[dineshkumar]

can i have two apply map function for single return

[teiswamsler]

Hi Dinesh

if i understand your question correct then yes

fx.

ApplyMap( 'Map', Field, ApplyMap('Map2', Field, 'Error') ) as FieldName

/Teis