Solved: LEFT JOIN in QlikView not giving the wanted output - Qlik Community

Report Inappropriate Content · ‎2013-10-10

I have one table:

Sessions:

Load

Timestamp,

...

[Authenticated user]

FROM bla-bla

I want to joins that table with the data from one QVD file. In the end effect, the table session should contain its fields as well as some fields from the second table.

So I did this:

LEFT JOIN (Sessions) 
LOAD 
     'DOMAIN\' & NT_USER & [Authenticated user], 
     ... 
     [Full_Name] 
FROM bla-bla-bla

[Authenticated user] field in the FIRST table has values with this format: 'DOMAIN\abc123' Furthermore, NT_USER has the following values: 'abc123'

The join is not working. I can´t see the data from the second table. Any advice?

edit:

Furthermore, here is how the preview looks like: de.tinypic.com/r/2086xxk/5 the left join should be made between [Authenticated user] fields in both tables, and the field "Full Name" should be added to the first table (without keeping second table)

swuehl · ‎2013-10-10

The table view seems reasonable to me. Before trying to join the tables, I would suggest creating three list boxes in the front end based on the model with the linked tables:

CalType, Authenticated User (key field) and full name

If you select CalType, does this filter the Auth user and full name values?

In your Auth user list box, do you maybe get similar values for the apparantly same user? Or with slight differences in spelling / cases?

View solution in original post

swuehl · ‎2013-10-10

Maybe it's just a typo in your posting, but I think you need alias the field like

LOAD

'DOMAIN\' & NT_USER AS [Authenticated user],

...

[Full_Name]

FROM bla-bla-bla

Report Inappropriate Content · ‎2013-10-10

I am not sure you understood my question correctly.

Column "[Authenticated user]" form Sessions Table has this format: "DOMAIN\abc123"

Now, I am trying to make a LEFT JOIN with Sessions table.

Therefore I am using 'DOMAIN\' & NT_USER.

NT_USER has this format: "abc123"

I am naming this [Authenticated user] so that QlikVIew can automatically join the tables.

After JOIN I want to extract Full_NAME column.

I hope this explanation helps.

swuehl · ‎2013-10-10

Yes, I think I've understood. Please compare your script snippet above with my correction:

'DOMAIN\' & NT_USER AS [Authenticated user],

     'DOMAIN\' & NT_USER & [Authenticated user],

sudeepkm · ‎2013-10-10

Are there any other fields (except [Authenticated user]) in the both the tables which are of same name.

I think your script is fine but for some reason the data is getting ignored as a result of join.

The join might be considering more than [Authenticated user] field.

If possible can you please mention all the field names from both the tables?

Report Inappropriate Content · ‎2013-10-10

I got this error message swuehl:

Feld nicht gefunden - <Authenticated user>

LEFT JOIN (Sessions)

LOAD

'DOMAIN\' & NT_USER & [Authenticated user],

Vorname & '|' & Nachname as Full_Name

FROM

QVD\VWL_User.qvd

(qvd)

Report Inappropriate Content · ‎2013-10-10

here it is: gist:6918259

Report Inappropriate Content · ‎2013-10-10

here is the whole script: gist:6918259

sudeepkm · ‎2013-10-10

I think you need to use:

'DOMAIN\' & NT_USER as [Authenticated user],

instead of
'DOMAIN\' & NT_USER & [Authenticated user], in your load script

Report Inappropriate Content · ‎2013-10-10

Yes, that is exactly what I use. (I copied the script after suggestions from swuehl)

I will "correct" it

Basically I need another suggestion