4 Replies Latest reply: Aug 24, 2015 4:49 AM by Hugo vanderFlier RSS

    Qlik Sense mapping load issue when selecting more than 2 field in sql select

    Hugo vanderFlier

      Hi

      I'm converting a script from qlikview to qlik sense.

      I have an issue with a mapping load when I select more than 2 fields in my SQL select statement. This data somehow gets loaded and is not deleted after the load is done  (and will create a synth key on field2 and field3 because I use those in another table as well).

       

      I guess this is a bug as it did work allright in qlikview, and the fields in the SQL select should not be loaded, but only the fields in the LOAD statement.

       

      Script:

      MapUsers:

      Mapping LOAD

        field1,

        (field2 & ' ' & Replace(field3, '_', ' '))

        ;

      SQL SELECT

      field1, field2, field3

      FROM table;

       

      Solution is to change the SQL SELECT:

      MapUsers:

      Mapping LOAD

        field1,

        u1

        ;

      SQL SELECT

      field1

      (field2 & ' ' & Replace(field3, '_', ' ')) AS u1

      FROM table;