Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Linking tables on fields with different data formats

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:

Capture1.JPG.jpg

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

Capture2.JPG.jpg

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

Capture3.JPG.jpg

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:

Capture4.JPG.jpg

Thank you

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Linking tables on fields with different data formats

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


talk is cheap, supply exceeds demand

View solution in original post

4 Replies

Re: Linking tables on fields with different data formats

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

MVP & Luminary
MVP & Luminary

Re: Linking tables on fields with different data formats

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


talk is cheap, supply exceeds demand

View solution in original post

juleshartley
Valued Contributor

Re: Linking tables on fields with different data formats

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.

Not applicable

Re: Linking tables on fields with different data formats

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