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;




      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');





      LET j = NoOfTables();



      do while j>0



        Let vTable = TableName(0);

        drop table '$(vTable)';

        let j= NoOftables();






      Comments, feedback and solutions greatly appreciated!