Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Vishal007
Contributor
Contributor

Conditional Loading of columns

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.

4 Replies
Saravanan_Desingh

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];
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Would "Load *" work in this case?

-Rob

Vishal007
Contributor
Contributor
Author

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.

 

Vishal007
Contributor
Contributor
Author

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.