Help with loading this into QV

[#1]

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

[Gysbert_Wassenaar]

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.

[RedSky001]

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

[swuehl]

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)]

[#5]

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..