Connect data from few tables

[Anonymous]

Good day!

In load script i load two tables:

Directory;

FOR Each File in filelist ('C:\ProgramData\QlikTech\QlikViewServer\Audit__*.log')

Data_from_Audit_files:

  LOAD [Server Started],

      Timestamp,

      Capitalize(Document) as Document,

    Type,

    User,

      Message,

     SheetCode,

      ObjectCode

  FROM

  '$(File)'

  (txt, utf8, embedded labels, delimiter is '\t', msq);

NEXT File;

Directory;

Info_Sheets:

LOAD Capitalize(FileName) as Document,

     Sheet,

     SheetID as SheetCode,

     SheetName,

     ObjectId as ObjectCode,

     Label as ObName

FROM

[for Audit\Sheets1.xlsx]

(ooxml, embedded labels, table is Sheet1);

Loading is successful. But when i choose ObName, i don't see any data in fields Type,User, Message,Timestamp...

What i do wrong ? How i must connect these tables?

Thanks

,

[JonnyPoole]

Seeing the  QVW will help. 

Either the values for 'document' are not the same between the 2 tables or the  documents that were selected have not been used on the server (and have no log references)

I suggest adding a 2nd document field in each load named differently

IE:

     Capitalize(Document) as [Document-AuditFiles],

     Capitalize(FileName) as [Document-Sheets],

Then add both these fields as list boxes and start clicking them to see if the values associate.

[Anonymous]

No, 'Document' field from both tables is the same and data is connected correctly by this field.

Also data is connected correctly by other key fields (SheetCode,ObjectCode).

My task - when i choose some data in ObNaame field to see:

Timestamp,

Capitalize(Document) as Document,

Type,

User,

from 1 table. (not it's not available)

There's structure in attachment !

[jonathandienst]

Hi

Because of the composite key, all 3 fields must be matching in both tables for there to be any association between a value in one table and values in the other table. Hover over the $Syn1 field in each table and see the subset ratio in each table. If they add up to 100%, then there is no association between the tables. If either of them contain less than 100%, then there are non-associated rows in the other table.

If you post your model or a sample that illustrates your problem, then someone will be able to help in more detail. It might be useful to post the spreadsheet and a couple of your log files.

HTH

Jonathan