Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Partner - Contributor II
Partner - Contributor II

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

regards

Anonymous
Not applicable
Author

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

Thiago_Justen_

What about this:

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

In both table.

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago
dwforest
Specialist II
Specialist II

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

What is the source?

Anonymous
Not applicable
Author

the data is coming from a qvd File.

vishsaggi
Champion III
Champion III

Use Autonumber(ID) AS KeyID