Excel Data to Qlikview Transformation as Excel

lakshmanvepuri — Sat, 16 Nov 2024 01:34:55 GMT

Hi Gurus,

Please let me know how do I get the Excel data in left to right side as mentioned in the screenshot.

Thanks

LK Vepuri

Re: Excel Data to Qlikview Transformation as Excel

kaushiknsolanki — Tue, 07 Jan 2020 08:53:11 GMT

Hi,

You should use the basic transformation while loading the data in Qlikview.

Your script should look like below.

LOAD ID,
Section,
Manager,
ChequeID,
Details
FROM
[Book1.xlsx]
(ooxml, embedded labels, table is Sheet1, filters(
Replace(1, top, StrCnd(null)),
Replace(2, top, StrCnd(null)),
Replace(3, top, StrCnd(null))
));

Regards,

Kaushik Solanki

topic Re: Excel Data to Qlikview Transformation as Excel in QlikView

Excel Data to Qlikview Transformation as Excel

Re: Excel Data to Qlikview Transformation as Excel