2 Replies Latest reply: May 18, 2016 4:38 PM by Marco Wedel RSS

    Hello friends, How can I control which columns are loaded for a QlikView table from a file based on user input?

    John Blomqvist

      Hi all,

       

      I am trying to control which columns are loaded for a QlikView table created from a file where the user controls which column to load.

       

      For example in a Excel spreadsheet you might have the following columns:

       

      OrderID,

      OrderDate,

      CustomerID,

      ProductID,

      SpecialNotes,

      SalesValue

       

      I would like to load the above table into QlikView, however it is up to the user which column is actually loaded.

       

      So in a normal load it might look like:

       

      Orders:

      LOAD

      OrderID,

      OrderDate,

      CustomerID,

      ProductID,

      SpecialNotes,

      SalesValue

       

      From

      <excel file>

       

      But what I want to do is control which column is shown in the Orders table.

       

      So for example, they want to load all the columns above except ProductID, and SpecialNotes. And maybe another time they might choose to remove SalesValue field only and keep all the others

       

      Anyone got any ideas how I can do this in QlikView please?