Help with table structure

[helen_pip]

Hello

I am looking for some help in the script in Qlikview which will help me produce a table ush as this.  I need to be able to produce such a table in the script, rather than in the body of the QVW, as I will be referencing the table in other parts of the script

I want to achieve a table which will look like this:

Country	Locations	location pcode	latitude	longitude	pcode	latitude2	longitude2	Referrals
uk	Andover	SP117SA	51.194142	-1.507834	SP117SA	51.194142	-1.507834	4
uk	Andover	SP117SA	51.194142	-1.507834	SP104RP	51.221722	-1.502514	3
uk	Andover	SP117SA	51.194142	-1.507834	SP101JY	51.212444	-1.468069	2
uk	Andover	SP117SA	51.194142	-1.507834	SP102HF	51.198956	-1.483524	10

I have attached a QVW which shows how the data is currently being stored.  Can anyone help me or get me started

Your help is very much appreciated

Thanks

Helen

[#2]

Hi,

I can´t understand the problem. As I see in the document, you already have a table (sheet2) loaded in the script, and it looks like the way you want it...

As I say, I think I didn´t understand the problem...