LEFT JOIN in QlikView not giving the wanted output

[#1]

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]

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

[#3]

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]

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]

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?

[#6]

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)

[#7]

here it is: gist:6918259

[#8]

here is the whole script: gist:6918259

[sudeepkm]

I think you need to use:

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

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

[#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