Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
jacobesalas
New Contributor II

Joining distinct values

I have a table with ID 01, 001, and 0001

I have another Table using one of those IDs.  when I join the tables I see all three joined.  Is there a way around this?

6 Replies
tiago_juncioni
New Contributor II

Re: Joining distinct values

Use Text(ID) for join, in both table.

regards

jacobesalas
New Contributor II

Re: Joining distinct values

unfortunately, this did not work.  Is there another way?

thiago_justen
Valued Contributor III

Re: Joining distinct values

What about this:

Replace ('ID','0','X') as NewID

In both table.

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
dwforest
Valued Contributor

Re: Joining distinct values

Did you try Text(ID) in the load script from the original source?

What is the source?

jacobesalas
New Contributor II

Re: Joining distinct values

the data is coming from a qvd File.

vishsaggi
Esteemed Contributor III

Re: Joining distinct values

Use Autonumber(ID) AS KeyID

Community Browser