Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm working on a qlikview desktop script. This script is loading from an excel sheet with 3 different sheets. I'm able to load the data, but the linking between the 3 sheets is not working properly.
I'm using a sheet called "Link" to link my first sheet with the the 3rd sheet.
Here is my script:
LOAD *
FROM
(ooxml, embedded labels);
LOAD *
FROM
(ooxml, embedded labels, table is Link)
LOAD *
FROM
(ooxml, embedded labels, table is People)
I see the corrolation between the first sheet and link happening. I don't see the happening between Link and People
.
ID between first sheet and second is DEV_ID and between second and 3rd is PERSON_ID.
Any help is greatly appreciated.
Will do. Thank You Sinan for your help. I'll work on better cleaning data and try uploading it.