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.
Maybe excel sheets with a few rows in them if they are not confidential?
This doesn't make sense. I created a new sheet with way less data and fake data to upload and I created a new qlik doc and its working. Let me strip down what I currently have and try uploading it since I don't want any confidential info.
Ya. When I cut the data and change values it all of a sudden does what it should.
But with the current data, It doesn't work and I can't upload it
I will say this. I see the coloration happening between the people sheet and the Link.
When I select a name, it links the PERSON_ID with the PERSON_ID on the Link Sheet and then it finds the DEV_ID on the LINK Sheet, but for some reason its not link with the Device Sheet. I thought I was going crazy so I grabbed the DEV_ID and searched for it in on excel and I find it.
If I remove the link sheet and put everything on one sheet it works just fine.
Is there a better way to do the linking any better?
Maybe put the person ID on the same sheet as the Device sheet as an array and then somehow explode it using a comma or something.
Example,
PersonID = Per1, Per2, Per3
and then explode that and use that to link with the Person Sheet?
There could be a hidden character in the column name.
I just used Excel's CLEAN function and changed the old column name to OLD. Same problem
Do me a favor, copy the same column name from another sheet and paste it into the problematic column to see if it fixes anything.
Same thing. But I discovered something. If I select the DEV_ID in qlikview it links everything together. Device info and people. But if I select the name while having the DEV_ID selected, it breaks. I deselected the DEV_ID same result. No workie. Let me try the clean for the name and try again.
Didn't make a difference, Hmm. This is a little weird.
At this point, It is a bit difficult to determine the cause of the problem without seeing some sample and it seems confidential. Although, I say this that sometimes I receive exact same files one from SQL Server and one from MySQL and the fields don't link due to hidden characters.
Try to upload some samples when you can.
Thanks