Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Table formatting.

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

2 Replies

Re: Table formatting.

You can use Generic Key word:

The Generic Load

MVP & Luminary
MVP & Luminary

Re: Table formatting.

You can try a generic load:

GENERIC

LOAD    

     ID,

     FieldLabel,

     FieldValue

FROM

     ....source...

WHERE

     FieldLabel <> 'Date'

     ;


talk is cheap, supply exceeds demand