apply map issue

[ioannagr]

Hello all 🙂

I have a concatenation of two tables.

In table B i have a field  1 as type

and in table A i have a field target as type and i load data where target=2 or 3 .

My applymap is like this   : Applymap('MapType', type, '-') as Type  and in MapType i took care of all 3 incidences 1,2,3.

It only works for table A though and for table B it gives '-' where it should be the label for 1.

What is going on?

[Ksrinivasan]

hi,

can you share exact data,

ksrinivasan 

[ioannagr]

Hello, my bad, i didn't do correctly the load * inline  . Thanks though 🙂