Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 sunny_talwar
		
			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
		
			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
		
			rubenmarin
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I was intended to do that way but I forgot to change it. 
