Excel Data to Qlikview Transformation as Excel

[lakshmanvepuri]

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

[kaushiknsolanki · Accepted solution]

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