Need help with data manipulation

[sunny_talwar]

Hey Guys -

I am working on something where I know I can get it done through work around, but was wondering if there is a better way to do it. Please note that this is just a sample and the actual data is huge + the script needs to be dynamic to handle the requirement.

Sample Data

Table:

LOAD * Inline [

ID, FIELD1, MONTHYEAR, VALUE

1, ABC,  11/01/2015, 10

1, ABC, 12/01/2015, 11

1, ABC, 01/01/2016, 12

1, ABC, 02/01/2016, 11

1, ABC, 03/01/2016, 12

1, DEF, 11/01/2015, 5

1, DEF, 12/01/2015, 4

1, GHI, 11/01/2015, 8

1, GHI, 12/01/2015, 9

2, ABC,  11/01/2015, 10

2, ABC, 12/01/2015, 11

2, ABC, 01/01/2016, 12

2, ABC, 02/01/2016, 11

2, ABC, 03/01/2016, 12

2, ABC, 04/01/2016, 16

2, DEF, 11/01/2015, 5

2, DEF, 12/01/2015, 4

2, GHI, 11/01/2015, 8

2, GHI, 12/01/2015, 9

];

I am attaching the expected output file with the sample application.

Update: Can you guys have a look please swuehl‌‌, MarcoWedel‌, jagan‌ MRKachhiaIMP‌ jontydkpi‌ cleveranjos‌

[sunny_talwar]

I can definitely run some test's, but at a later time. Right now I am time crunched and will use Stefan's script as I have already implemented that and it seems to work

But thanks guys

Sunny

[rubenmarin]

I was intended to do that way but I forgot to change it.