Discussion Board for collaboration on QlikView Scripting.
I have a request to load multi columns from excel file
I do not know how many rows and columns I have
it is very simple table .
I get multi columns and need to create 2 columns table
enclosed please find excel file with one sheet
on the left is the input format
and in the right is the output format
Go to Solution.
try below this will load all the columns dynamically using * prefix
(ooxml, embedded labels, table is Sheet1);
where not Exists(Description,Balcode);
DROP Table Data;
DROP Field Col;
(ooxml, embedded labels, header is 1 lines, table is DATA);
It works great ,
but my problem is that I do not know how many columns I am going to have
it can be 3 or 7
with new rows that will be added by the CFO
can we fix it
HAPPY NEW YEAR
Welcome & HAPPY NEW YEAR TO YOU AS WELL