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
