Qlik Community

QlikView Integrations

Discussion Board for collaboration on QlikView Integration.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
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

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.