Discussion board where members can get started with QlikView.
Please let me know how do I get the Excel data in left to right side as mentioned in the screenshot.
You should use the basic transformation while loading the data in Qlikview.
Your script should look like below.
LOAD ID,Section,Manager,ChequeID,DetailsFROM[Book1.xlsx](ooxml, embedded labels, table is Sheet1, filters(Replace(1, top, StrCnd(null)),Replace(2, top, StrCnd(null)),Replace(3, top, StrCnd(null))));
View solution in original post