topic Re: Conditional Loading of columns in QlikView

Conditional Loading of columns

Vishal007 — Mon, 26 Jan 2026 16:26:21 GMT

I have excel tables in files that i want to load. File names are T1, T2, T3, T4.

In T1 there are 5 columns : Name, Grade, Rollno, Percentage, Country.

Other Tables : Name, Rollno, Precentage.

I want to write conditions that, while loading it would load all columns from T1 and from others it should exclude last column or the chosen column.

IF(FileName()="T1")THEN
LOAD*;
ELSE
LOAD [Rollno],
[Percentage]

FROM
[C:\Users\vigne\Desktop\VISHAL\Qlik\Excel\Dynamic Loading\*]
(ooxml, embedded labels, table is Sheet1);

I made this code, but it isn't working right. Its first condition is always coming false. I also want the second load to be dynamic.

Example : Load all except the last column.

Please explain the solutions.

Thankyou.

Re: Conditional Loading of columns

Saravanan_Desingh — Tue, 24 Aug 2021 12:50:36 GMT

Try something like this,

tab: LOAD Name, Grade, Rollno, Percentage, Country FROM [T1]; Concatenate(tab) LOAD Name, Rollno, Percentage FROM [T2]; Concatenate(tab) LOAD Name, Rollno, Percentage FROM [T3]; Concatenate(tab) LOAD Name, Rollno, Percentage FROM [T4];

Re: Conditional Loading of columns

rwunderlich — Tue, 24 Aug 2021 21:10:58 GMT

Would "Load *" work in this case?

-Rob

Re: Conditional Loading of columns

Vishal007 — Wed, 25 Aug 2021 04:53:17 GMT

I included the code that I wrote. hope it clarifies my question.

I made this code, but it isn't working right. I also want the second load to be dynamic.

Re: Conditional Loading of columns

Vishal007 — Wed, 25 Aug 2021 04:53:36 GMT

I included the code that I wrote. hope it clarifies my question.

I made this code, but it isn't working right. I also want the second load to be dynamic.