3 Replies Latest reply: Dec 4, 2017 4:40 AM by Andy Weir RSS

    Problem in loading table by sql query in qliksense

    Balaji SJ

      When i paste sql query in Data load editor and load the data, it is successful. The required table is generated Data manager. But when i load data in data manager and select edit sheet option, the table is not generated in the sheet for visualization.

       

      I am newbie to qliksense, Please provide solution for this issue.

       

       

      query generated in data load editor - for reference

       

       

      Unqualify *;

       

       

      [members_*******************]:

      LOAD

      [customerid],

      [givenname],

      [fullname],

      Date([dob] ) AS [dob],

      [age],

      [gender_description],

      [emailaddress],

      [preferlanguagename],

      [pointsearned],

      [pointsadjusted],

      [pointswithheld],

      [pointsredeemed],

      [pointsexpired],

      [totalpointsearned],

      [pointsnearexpiry],

      [pointsavailable],

      [firsttxndate],

      [lastpurchaseddate]

      RESIDENT [members];

      DROP TABLE [members];

       

       

      RENAME TABLE [members_****************] to [members];