topic Connect data from few tables in QlikView

Connect data from few tables

Anonymous — Mon, 06 Oct 2014 11:40:09 GMT

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

Re: Connect data from few tables

JonnyPoole — Mon, 06 Oct 2014 15:36:02 GMT

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.

Re: Re: Connect data from few tables

Anonymous — Tue, 07 Oct 2014 05:06:38 GMT

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 !

Re: Connect data from few tables

jonathandienst — Tue, 07 Oct 2014 05:59:42 GMT

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