How to access one table field in Qliksense script?

[#1]

[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

[shree909]

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`;