Linking tables on fields with different data formats

[#1]

Hi

I have to join two tables, in order to bring the Industry field, but the format of the data is totally different, however the values are the same:

See example

This is what happens when I select an industry:

This is what happens when I select company 45 from the table on the left:

This is what happens when I search for 45 in the listbox:

So the problem is linking two tables with the same values, but different data sources.. Unsure how to solve this

Any ideas?

ps. These are my tables before I joined them:

Thank you

[ashfaq_haseeb]

Hi,

Try to convert date in one format by using Date#() of ALT()

If you have number as string convert them to number by using num#().

Hope it help

Regards

ASHFAQ

[Gysbert_Wassenaar · Accepted solution]

Use the num#() function to make numbers of the string values from the table with the string values.

[juleshartley]

It looks like your SpiderID is being held as a string. You need to explicitly convert this to the same format as the field you are joining to. If there are string fields as well as integers then the safest may be to convert both into strings... Be sure to trim etc. if there are any chances of trailing / leading spaces.

[#5]

Thank you Gysbert Wassenaar, this is exactly what I needed!