6 Replies Latest reply: Jun 26, 2017 8:57 PM by Ricky Scheiber RSS

    Is it possible to upload two QVWs (from unique sources) into one QVW via a BINARY Load?

    Ricky Scheiber

      Started with data from two excel files with two sheets each that I concatenated successfully.. stored each concatenation as two separate tables...the below follows the path I took for ONE excel file and ONE concatenation....

       

      I can perform a BINARY load successfully if I do one Table at a time, but I need data from both tables in my QVD. Here's my path so far - help is greatly appreciated

       

      CAPFactTable:
      LOAD*
      FROM
      [i:\CAP_Profile\Desktop\Landing Page Items\CAPs\Feb and March CAP Data_Raw_060117_V2.xlsx]
      (
      ooxml, embedded labels, table is [Feb 28 CAPs]);

      Concatenate(CAPFactTable)

      LOAD*
      FROM
      [i:\CAP_Profile\Desktop\Landing Page Items\CAPs\Feb and March CAP Data_Raw_060117_V2.xlsx]
      (
      ooxml, embedded labels, table is [Mar 28 CAPs]);



      I then stored each table as a qvd....

       

       

      STORE CAPFactTable into O:\Report QV automation\04_QVD_Files\CAPFactTable.qvd(qvd);


      EXIT Script;

       

      Which then allowed me to load each table separately....

       

      CAPFactTable:

      LOAD*

      FROM CAPFactTable.qvd(qvd); 

       

      And finally perform a BINARY load of my QVD...

       

       

      BINARY  O:\Report QV automation\03_QVD_Maker\Monthly_Reporting_DMG_Revised.qvw; 

      SET ThousandSep=',';
      SET DecimalSep='.';
      SET MoneyThousandSep=',';
      SET MoneyDecimalSep='.';
      SET MoneyFormat='$#,##0.00;($#,##0.00)';
      SET TimeFormat='h:mm:ss TT';
      SET DateFormat='M/D/YYYY';
      SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
      SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
      SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

      exit script

      My problem is that this table, 'CAPFactTable' only contains data from one source. I also want to upload 'IssueFactTable' that I have created in a parallel fashion in a BINARY upload within the SAME QVD, even though they are from unique excel files.

       

      Does this make sense? The help is greatly appreciated!