topic Re: Linking tables on fields with different data formats in QlikView

Linking tables on fields with different data formats

Mon, 23 Jun 2014 09:37:26 GMT

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

Re: Linking tables on fields with different data formats

ashfaq_haseeb — Mon, 23 Jun 2014 09:40:21 GMT

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

Re: Linking tables on fields with different data formats

Gysbert_Wassenaar — Mon, 23 Jun 2014 09:40:59 GMT

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

Re: Linking tables on fields with different data formats

juleshartley — Mon, 23 Jun 2014 09:42:31 GMT

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.

Re: Linking tables on fields with different data formats

Mon, 23 Jun 2014 11:42:35 GMT

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