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: 
raadwiptec
Creator II
Creator II

excel

I have the following input source in Excel format. Iam looking to transpose it but not getting the correct format. So here i have the Month

07 in the first header line.. rest of the header lines on the first line is empty

          

070707
FlagInvoicecodeInvoiceNumberCustomerNameProductProduct descriptionYearFinal QtyFinal priceFinal value
N2100877132566 Product1 2017  650.000 €                 0,11 € 68.886,00
Y2100856132587 Product2 2017  550.000 €                 0,11 € 58.886,00

Any sugg

1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

Hi raadwiptec,

have a look at the attached qvw!

I adapted rbechers really nice solution from this post Re: Transpose to your excelfile.

Hope this helps!

View solution in original post

12 Replies
Anil_Babu_Samineni

Can you send Excel format? And expected result please

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
el_aprendiz111
Specialist
Specialist

Hi,

LOAD Flag,
Invoicecode,
InvoiceNumber,
CustomerName,
Product,
[Product description],
Year,
[Final Qty],
[Final price],
[Final value]
FROM
[..\..\Desktop\web_Qlik\Resultado10\Active.xlsx]
(
ooxml, embedded labels, table is empty, filters(
Remove(Row, RowCnd(CellValue, 1, StrCnd(null)))
));

raadwiptec
Creator II
Creator II
Author

hi fer , i need 07 as month column also..

raadwiptec
Creator II
Creator II
Author

anil attached..

Siva_Sankar
Master II
Master II

I attached the file. let me know is that what you want?

raadwiptec
Creator II
Creator II
Author

hi siva,

is this for my issue or somebody else?

Siva_Sankar
Master II
Master II

for you.. or let me know your expected output?

raadwiptec
Creator II
Creator II
Author

hi siva,

did you check my attached excel sheet? you can see my requirement there and what output iam looking for

raadwiptec
Creator II
Creator II
Author

hi guys any luck here