topic Re: Data Transformation in Flat files in QlikView

Data Transformation in Flat files

Anonymous — Tue, 12 May 2015 03:48:03 GMT

Please see attached example. Is there a way in the Qlikview script to modify the data from the Excel Format to the Desired Qlikview Format in the attached example using the transformation step, crosstable or another function in the script. Please let me know.

Thanks

Re: Data Transformation in Flat files

Tue, 12 May 2015 05:38:42 GMT

Do you want the qlikview chart to look like as it shown in the excel file? or you need to access this excel file data into qlikview script.

Re: Data Transformation in Flat files

Anonymous — Tue, 12 May 2015 05:43:52 GMT

just load excel file into qlikview so that you can understand how the data reflect in qlikview...

i want to show proper data in qlikview by using this excel file...basically it is not associating

Re: Data Transformation in Flat files

Gysbert_Wassenaar — Tue, 12 May 2015 05:53:02 GMT

Yes, that's possible. I've created a qlikview document that pretty much does this: multi_header_pivot_import.qvw. It won't work directly with your file though. The labels in cells A1, B1 and C1 should be put in A3, B3 and C3. And you have merged cells in columns A and B. My example doesn't work with that yet, but adding code to do that is possible. You'd need to change line 94 of the load script to something like this:

($(vType), embedded labels, header is $(vHeaders) lines, table is $(vSheet), filters(Replace(1, top, StrCnd(null)),Replace(2, top, StrCnd(null))) );