8 Replies Latest reply: Jun 23, 2015 11:02 AM by Brian Hart RSS

    Data Load Editor: Manipulating a table in the editor

      In Qlik Sense, have created a connection to an Oracle database.  I would like to load some data, but I want to make some changes to the table before loading it.  Here's what the table looks like coming from the database.

       

      Format from database:

      Field_NameIDchar_value

      field1

      001field1_001
      field1002field1_002
      field1003field1_003
      field2001field2_001
      field2002field2_002
      field2003field2_003
      field3001field3_001
      field3002field3_002

       

       

      And here's what I'd like to load into Qlik Sense.

      Desired format to load into Qlik Sense:

      IDfield1field2field3
      001field1_001field2_001field3_001
      002field1_002field2_002field3_002
      003field1_003field2_003NA

       

      Here's what the script looks like to load the top table:

      LIB CONNECT TO 'database';

       

      LOAD "FIELD_NAME",

          "ID",

          "CHAR_VALUE";

       

      SQL SELECT "FIELD_NAME",

          "ID",

          "CHAR_VALUE",

       

      FROM database."table";

       

       

      What do I need to do in the data load editor to load the table on the bottom given the table on the top?


      Thanks for your help!

      Brian