Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
You can use Generic Key word:
You can try a generic load:
GENERIC
LOAD
ID,
FieldLabel,
FieldValue
FROM
....source...
WHERE
FieldLabel <> 'Date'
;