Qlikview loading Excel line problem

[alexandermllr]

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

[antoniotiman]

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]

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]

I achieved this through enable transformation import assistant

[alexandermllr]

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]

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]

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

Thanks for your help!

[antoniotiman · Accepted solution]

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]

Thank you!

That worked