Mapping Load issue

[shama_deshpande1]

Hi,

I have a maping table containing values as ID and value and I am using apply map function on a table containing values as ID1 and value1. In mapping table the ID field is num but in table 2 the ID1 field is text. So the apply map is not happening even when the values are exactly same.

Request all to help me with this.

[kaushiknsolanki]

Hi,

In order to work Applymap properly, you should have both the fields same even the format. 

You can do one thing, wither convert the ID of table1 to text or convert the ID field of Table2 to Num.

You can use the text() or Num() functions to do this.

Regards,

Kaushik Solanki

[Ezir]

Hi @shama_deshpande1,

See if this below helps:

ApplyMap('MapName',Num#(ID1),Null())

Regards,

Ezir