1 Reply Latest reply: Jan 13, 2016 9:36 AM by sree anaarasi Branched from an earlier discussion. RSS

    Re: How to access one table field in Qliksense script?

    Bibhuti Sahoo

      [header]:

      SELECT columns[0] as column_0, columns[1] as column_1, columns[2] as column_2, columns[3] as column_3, columns[4] as column_4, columns[5] as column_5, columns[6] as column_6, columns[7] as column_7, columns[8] as column_8, columns[9] as column_9, columns[10] as column_10, columns[11] as column_11 FROM `dfs`.`default`.`x1.csv`;

       

       

      [finalInputData_withCHT]:

      SELECT columns[0] as column_0, columns[1] as column_1, columns[2] as column_2, columns[3] as column_3, columns[4] as column_4, columns[5] as column_5, columns[6] as column_6, columns[7] as column_7, columns[8] as column_8, columns[9] as column_9, columns[10] as column_10, columns[11] as column_11 FROM `dfs`.`default`.`x2.csv`;

       

       

      I want to assign header table column_0 to finalInputData_withCHT table column_0

      Is it possible to assign?? please suggest me.

       

      Thanks,

      Bibhuti

        • Re: How to access one table field in Qliksense script?
          sree anaarasi

          Use qualify  in your script

           

           

          Qualify *;

           

          [finalInputData_withCHT]:

          Load * ;

          SELECT columns[0] as column_0, columns[1] as column_1, columns[2] as column_2, columns[3] as column_3, columns[4] as column_4, columns[5] as column_5, columns[6] as column_6, columns[7] as column_7, columns[8] as column_8, columns[9] as column_9, columns[10] as column_10, columns[11] as column_11 FROM `dfs`.`default`.`x2.csv`;