Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 rammuthiah
		
			rammuthiah
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I have data with several dates and want to show like below.
Sample input data and output given below
Input :
| PN | CN | Date | Value | 
| 1 | A | 4/9/2017 | 1 | 
| 1 | A | 5/9/2017 | 
 | 
| 1 | B | 5/9/2017 | 
 | 
| 1 | B | 6/9/2017 | 
 | 
| 1 | B | 7/9/2017 | 
 | 
| 2 | A | 4/9/2017 | 1 | 
| 2 | B | 3/9/2017 | 
 | 
| 2 | B | 5/9/2017 | 
 | 
| 2 | C | 4/9/2017 | 1 | 
| 2 | C | 5/9/2017 | 
 | 
Should be like :
 
					
				
		
 vinieme12
		
			vinieme12
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		just Pivot the Date field in a Pivot Table or Look at Generic Load
 beck_bakytbek
		
			beck_bakytbek
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		 
					
				
		
 jagan
		
			jagan
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
Try like this
Data:
LOAD
*,
'Date' & AutoNumber(YourDateFieldName) AS DateNumber
FROM DataSource;
Now use Pivot table, drag DateNumber and your date field to top then you can get the similar layout.
Regards,
Jagan.
