Link Problems between excel sheets

[#1]

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.

[sinanozdemir]

Maybe excel sheets with a few rows in them if they are not confidential?

[#3]

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.

[#4]

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

[#5]

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?

[sinanozdemir]

There could be a hidden character in the column name.

[#7]

I just used Excel's CLEAN function and changed the old column name to OLD. Same problem

[sinanozdemir]

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.

[#9]

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.

[#10]

Didn't make a difference, Hmm. This is a little weird.

[sinanozdemir]

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