topic Help with loading this into QV in QlikView

Help with loading this into QV

Tue, 21 May 2013 16:12:04 GMT

Hi all,

Does anyone have any idea how i can load the attachment into QlikView please? i am completely stuck! apparently the format cannot be changed!

Thanks

Chris

Re: Help with loading this into QV

Gysbert_Wassenaar — Tue, 21 May 2013 16:20:37 GMT

Forget it. This is a totally unworkable format. Stick to using Excel because a spreadsheet application is the only kind of software where data in this format is at least somewhat usable.

Re: Help with loading this into QV

RedSky001 — Tue, 21 May 2013 16:30:33 GMT

The spreadsheet formatted, is the accountant having a joke with you? It's in a complete mess.

You need some sort of consistency and rules with the source data before you can automate loading it into any tool.

On another note be cautious about uploading company data like this to a public forum as you maybe in breach of data protection legislation

Re: Help with loading this into QV

swuehl — Tue, 21 May 2013 16:37:53 GMT

It seems to me that there is somekind of structure in your data, repeated every 8 lines, right?

So, at worst, you can perform 8 LOADs, one per line of your structure and parse in the field values using @ column specifier (use ... where mod(recno(),8)=1 to get the 1., 9., 17. line etc.)

Create a rowno() AS StructureID in your loads which you use at the end to join your fields into one table.

Seems like very dirty work, so if you can get the data in a more appropriate format, do so.

[edit: attached a sample to show how to do this (only for few fields, To: Company name scrambled by me)]

Re: Help with loading this into QV

Tue, 21 May 2013 16:39:09 GMT

i thought as much! just wanted to check i wasnt being stupid!

I changed reference numbers/values on the attachment so i thought it would have been ok but have deleted it now just incase.

Thanks both for your input..