4 Replies Latest reply: Nov 21, 2014 7:26 AM by Puttemans Johan RSS

    resident

    Laura Sébille

      Hey everyone,

       

      I was looking a qlikview where the script was wrtitten by someone who left the company.

       

      There is something that makes me feel a bit confused :/

       

      In the first tab, there is this piece of code :

       

      left join (tableA)

      field1,

      field2

      resident OneTable;

       

      To me, we use resident to use a table we have previously loaded in the script but here, I cannot find 'OneTable' anywhere in the script. (I used CTRL + F) How is it possible ?

       

      Might there be a hidden part of the script ?*

       

      Thanks for your help

        • Re: resident
          pradeep t

          check.. if there is any Binary Load  statement available.

          • Re: resident
            Puttemans Johan

            Hi Laura,

             

            The table could be inserted into the programmation in a different way. In my script (also scripted mainly by someone else), the 'call' function is sometimes used to create a table.With this function, you do manipulate data, but you don't see it in your script. This is because the actual script for the call is found elsewhere.

             

            e.g.

              CALL ScanFolderTrain ('$(vFolderSourceData)\TXT\');

            will do

            sub ScanFolderTrain( Root)

            for each FileExtension in 'txt'
              for each FoundFile in filelist( Root & '*nmbsoutput_*.' & FileExtension)

               Filelist:
               LOAD
                 MOAR_ID,
                 MOAR_SUB_ID,
                 MORO_ID,
                 Origin,
                 Destination,
                 TrackNr,
                 TrainKey,
                 Trainnummer,
                 From,
                 To,
                 From_ptCar,
                 To_ptCar,
                 Hour as Hour,
                 Departure,
                 Arrival,
                 Duration,
                 Penalty,
               FROM [$(FoundFile)] (txt)
            //   WHERE TrackNr >0;
            ;
              next FoundFile
            next FileExtension

            //DROP Field Day, Hour;
            end sub

             

            And the ScanFolderTrain is a .QVS file that sits in a library folder.

             

            In this example, the table Filelist is made.

            In my script, the command is followed by a rename command for the filelist table, and that is how I can trace back. In yours, this may not be done, but the table may reside in memory untill used.

             

            Hope this helps...

             

            Johan