6 Replies Latest reply: Nov 20, 2015 2:08 PM by Tony Iantorno RSS

    How does one pull Data Tables out of a QVF file?

    Tony Iantorno

      I have pulled tabled tables out of a QVD file, but I am now needing to pull all the tables out a .qvf file as .txt files.

       

      I have tries using a binary load similiar to what I have done in QlikView using a QVD, but have been unsuccessful using a binary load on a QVF file.

       

      I have managed to write a script that does pull the tables but only half of the tables are being created.

       

      Here is the script;

       

      LOAD

          @1

      FROM [lib://File path/myapp.qvf]

      (txt, codepage is 1252, no labels, delimiter is '\t', msq);

       

      for i = 0 to NoOfTables() -1

       

       

        Let vTable = TableName(i);

        

        Store '$(vTable)' INTO [lib://File path/'$(vTable).TXT']  (txt, delimiter is '\t');

       

      next

       

       

      LET j = NoOfTables();

       

       

      do while j>0

       

       

        Let vTable = TableName(0);

        drop table '$(vTable)';

        let j= NoOftables();

       

      Loop

       

       

       

      Comments, feedback and solutions greatly appreciated!

       

      Thanks,

       

      Tony