excel

[raadwiptec]

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

[Anil_Babu_Samineni]

Can you send Excel format? And expected result please

[el_aprendiz111]

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]

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

[raadwiptec]

anil attached..

[Siva_Sankar]

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

[raadwiptec]

hi siva,

is this for my issue or somebody else?

[Siva_Sankar]

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

[raadwiptec]

hi siva,

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

[raadwiptec]

hi guys any luck here