topic Table formatting. in QlikView

Table formatting.

Wed, 25 Nov 2020 16:16:04 GMT

Hi I Have table like below...

ID FieldLabel FieldValue

1 Long 50.8765

1 Lat -87.6543

1 Date 5/27/16

2 Long 40.6785

2 Lat -32.6754

2 Date 5/27/16

I want to format as below.How can I do that.I dont want the Date row data.How can I script this out ?

ID Long Lat

1 50.8765 -87.6543

2 40.6785 -32.6754

Thanks much...

sunny_talwar — Fri, 27 May 2016 14:10:54 GMT

You can use Generic Key word:

Gysbert_Wassenaar — Fri, 27 May 2016 14:11:47 GMT

You can try a generic load:

GENERIC

LOAD

ID,

FieldLabel,

FieldValue

FROM

....source...

WHERE

FieldLabel <> 'Date'

;