Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

alexandermllr
Contributor

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

Tags (3)
1 Solution

Accepted Solutions
antoniotiman
Honored Contributor III

Re: Qlikview loading Excel line problem

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;

8 Replies
Highlighted
antoniotiman
Honored Contributor III

Re: Qlikview loading Excel line problem

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
Valued Contributor II

Re: Qlikview loading Excel line problem

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
Valued Contributor II

Re: Qlikview loading Excel line problem

I achieved this through enable transformation import assistant

alexandermllr
Contributor

Re: Qlikview loading Excel line problem

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
Honored Contributor III

Re: Qlikview loading Excel line problem

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
Contributor

Re: Qlikview loading Excel line problem

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

Thanks for your help!

antoniotiman
Honored Contributor III

Re: Qlikview loading Excel line problem

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
Contributor

Re: Qlikview loading Excel line problem

Thank you!

That worked