Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a problem with loading this Excel file in Qlikview.
How can I load every Details line for the Product?
I hope someone can help me!
Thanks
Try this
Table:
LOAD If(IsNull(Product),Peek(Product),Product) as Product,Details1,
If(IsNull(Ammount),Peek(Ammount),Ammount) as Ammount,Details;
LOAD Product,'Dectails'&Autonumber(Details) as Details1,
Ammount,
Details as Details
FROM [Mappe2.xlsx]
(ooxml, embedded labels, table is Tabelle1);
Generic LOAD Product,Ammount,Details1,Details Resident Table;
Drop Table Table;
Hi Alexander,
LOAD If(IsNull(Product),Peek(Product),Product) as Product,
If(IsNull(Ammount),Peek(Ammount),Ammount) as Ammount,Details;
LOAD Product,
Ammount,
Details
FROM
(ooxml, embedded labels, table is Tabelle1);
Regards,
Antonio
Directory;
LOAD Product,
Ammount,
Details
FROM
Mappe1.xlsx
(ooxml, embedded labels, table is Tabelle1, filters(
Replace(1, top, StrCnd(null)),
Replace(2, top, StrCnd(null))
));
I achieved this through enable transformation import assistant
Thank you
But then i have the Ammount and Product 4 or 5 times.
Is it possible to to make for every Details line an extra field?
Product, Ammount, Details 1, Details 2, Details 3....
Try like this
Table:
LOAD If(IsNull(Product),Peek(Product),Product) as Product,
If(IsNull(Ammount),Peek(Ammount),Ammount) as Ammount,Details;
LOAD Product,
Ammount,
Details
FROM
(ooxml, embedded labels, table is Tabelle1);
Generic LOAD Product,Details,Ammount Resident Table;
Drop Table Table;
I want to have a table like this. Attached the file.
Thanks for your help!
Try this
Table:
LOAD If(IsNull(Product),Peek(Product),Product) as Product,Details1,
If(IsNull(Ammount),Peek(Ammount),Ammount) as Ammount,Details;
LOAD Product,'Dectails'&Autonumber(Details) as Details1,
Ammount,
Details as Details
FROM [Mappe2.xlsx]
(ooxml, embedded labels, table is Tabelle1);
Generic LOAD Product,Ammount,Details1,Details Resident Table;
Drop Table Table;
Thank you!
That worked