Table formatting.

[#1]

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]

You can use Generic Key word:

The Generic Load

[Gysbert_Wassenaar]

You can try a generic load:

GENERIC

LOAD    

     ID,

     FieldLabel,

     FieldValue

FROM

     ....source...

WHERE

     FieldLabel <> 'Date'

     ;