Field format help

[mahitham]

Hi Experts,

Can any one please help me on below issue.

I have two tables called Table 1 and Table 2 which contains Name field. Based on this Name field linked these two tables.

These two tables Name field has '8E36' record but its showing as two separate records after linking as well instead of one.

Please help me to fix this issue.

Thanks in advance

[JordyWegman · Accepted solution]

Hi,

In your script, use:

Text(Name) as Name

Jordy

Climber 

[lironbaram]

hi 

what happens that Qlik engine is identifying one field as text and one as numeric

you can wrap the field in the script like this 

text(Name) as Name