7 Replies Latest reply: Jan 1, 2014 12:04 PM by Chandramohan Reddy RSS

    Load from an existing QLikView table

      all,

       

      I would like to separate LOAD (in the main script) from clean up operations (in a clean up script).

       

      also, I would like to load data in the clean up script from tables that i obtained loading data in the main script. so far i have

       

      accountInfo:

      LOAD Country,

           [Corporate Account],

           [Sales Account],

           [Billing Account]

      FROM

      [F:\WORK\Ex3\Revenue.xls]

      (biff, embedded labels, table is Account$)

       

      in the main script. and this in the clean up script:

       

      CleanUpMap:

      mapping load * inline [

      x, y

      'LTD.', 'LIMITED'

      'LTD', 'LIMITED'

      ];

       

       

      LOAD Country,

           [Corporate Account],

           [Sales Account],

           MapSubString('CleanUpMap',[Billing Account]) as [Billing Account]

      FROM accountInfo

       

      and this is not compiling as QLikView looks for the file accountInfo in the current folder.

       

      Do you have an idea ?

       

      Thanks