topic excel in QlikView

excel

raadwiptec — Wed, 25 Nov 2020 16:16:04 GMT

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

							07	07	07
Flag	Invoicecode	InvoiceNumber	CustomerName	Product	Product description	Year	Final Qty	Final price	Final value
N	2100877	132566		Product1		2017	650.000	€ 0,11	€ 68.886,00
Y	2100856	132587		Product2		2017	550.000	€ 0,11	€ 58.886,00

Any sugg

Re: excel

Anil_Babu_Samineni — Sun, 23 Apr 2017 16:14:41 GMT

Can you send Excel format? And expected result please

Re: excel

el_aprendiz111 — Sun, 23 Apr 2017 16:26:41 GMT

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

Re: excel

raadwiptec — Sun, 23 Apr 2017 16:50:17 GMT

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

Re: excel

raadwiptec — Sun, 23 Apr 2017 16:52:54 GMT

anil attached..

Re: excel

Siva_Sankar — Mon, 24 Apr 2017 03:07:19 GMT

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

Re: excel

raadwiptec — Mon, 24 Apr 2017 06:53:09 GMT

hi siva,

is this for my issue or somebody else?

Re: excel

Siva_Sankar — Mon, 24 Apr 2017 06:56:51 GMT

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

Re: excel

raadwiptec — Mon, 24 Apr 2017 07:09:30 GMT

hi siva,

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

Re: excel

raadwiptec — Wed, 26 Apr 2017 09:10:52 GMT

hi guys any luck here

Re: excel

Frank_Hartmann — Wed, 26 Apr 2017 15:39:47 GMT

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!

Re: excel

Frank_Hartmann — Thu, 27 Apr 2017 11:53:36 GMT

Did this solve your problem?

If yes, then please close the thread by marking correct and helpful answers!

If not, please let us know the problems you are facing .....

Re: excel

raadwiptec — Fri, 28 Apr 2017 06:18:11 GMT

hi frank man thanks indeed for your help