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?
Use Text(ID) for join, in both table.
unfortunately, this did not work. Is there another way?
Did you try Text(ID) in the load script from the original source?
What is the source?
the data is coming from a qvd File.
What about this:
Replace ('ID','0','X') as NewID
In both table.
Use Autonumber(ID) AS KeyID
Retrieving data ...