6 Replies Latest reply: Oct 7, 2014 3:58 AM by Chandana Kumara RSS

    Connection of two tables

    Андрей Шепель

      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?

       

      p.s. Structure of connection in attached file.

       

      Thanks