Discussion Board for collaboration on QlikView Scripting.
Hi, I have a problem with a application, and I don´t understand why.
I want to add a new table and create a key between the new table and an existing table, using a field productID, a 16 digit number, ex 1002344001022349.
Even though the exact same productID-numbers exists in both of the tables they don´t seem to connect.
My guess is that the format of productID is different in the two tables. But even if I try using num(productID) or text(productiD) it still doesn´t work.
Can anyone help me figure out why this is happening?
I remember some problems with large integer numbers not being recognized as numbers on load, but as strings. Can't find the thread at the moment.
What if you try (as an experiment for the moment) to force QV to treat your ID as a string by adding text to the field values, i.e. by using a concatenation
productID & '-PID' as productID
then you should also check that the strings have the same length, maybe using len() function or trim() to remove spaces in front and at the end of your characters.
Could you upload a small sample here?
Thanks for your answer!
I tried concatenation without success.
As you can see below the format from the two tables looks a bit different.
I also tried trim without success. When I used len(productID) the lengt is 15 for one table and 20 for the other.
Have you tried
'PID' & num(productID,'0000000000000000') as productID
e.g. force a 16 digit integer formatting (BTW, I noticed that both PID numbers in your above post only show 15 digits?).
Hi, I just tried to do like that,
But unfortunately, still doesn´t work.
Hans: do try putting num(ProductID) as ProductID with the preceding load.
I resolved a similar issue this way...hope it works for you too.