Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have a situation where the DW incremental process is generating negative and positive hash values for keys. Wondering if the negative key values will have any impacts on qlik data model and require any special handling or it should be fine and work as any other values ? Really appreciate any insights on this. Attached sample/dummy data for reference.
Thank you,
Ramya
No special handling but what I observed is if digits are more than 14, key field will be treated as a text type. As I see you have got more than 14 digits in your key so there will be a text match but it works and it will treat negative sign as char '-'.
Qlik handles numeric values up to 14 digits only.
I just tried this sample -
Table1:
Load * inline [
Key, Sales
-123456789123456, 200
-765432109123456, 300
];
Table2:
Load * inline [
Key, Cost
-123456789123456, 100
-765432109123456, 200
];
Thanks,
Thanks,
DJ
No special handling but what I observed is if digits are more than 14, key field will be treated as a text type. As I see you have got more than 14 digits in your key so there will be a text match but it works and it will treat negative sign as char '-'.
Qlik handles numeric values up to 14 digits only.
I just tried this sample -
Table1:
Load * inline [
Key, Sales
-123456789123456, 200
-765432109123456, 300
];
Table2:
Load * inline [
Key, Cost
-123456789123456, 100
-765432109123456, 200
];
Thanks,
Thanks,
DJ
Thank you so much for the response DJ. I read about the 14 digit limit but was not clear, if it will be fine with text or not. We are not going to display the keys on the UI, as long as the keys as text type works in the script that should be fine.
Ramya