Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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];
Would "Load *" work in this case?
-Rob
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.
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.