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: 
alexandermllr
Creator
Creator

Qlikview loading Excel line problem

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

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

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;

View solution in original post

8 Replies
antoniotiman
Master III
Master III

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

techvarun
Specialist II
Specialist II

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))

));

techvarun
Specialist II
Specialist II

I achieved this through enable transformation import assistant

alexandermllr
Creator
Creator
Author

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....

antoniotiman
Master III
Master III

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;

alexandermllr
Creator
Creator
Author

I want to have a table like this. Attached the file.

Thanks for your help!

antoniotiman
Master III
Master III

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;

alexandermllr
Creator
Creator
Author

Thank you!

That worked