Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
 shekhar_analyti
		
			shekhar_analyti
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi All ,
What should be data model , when three table share two similar fields having date related attributes ?
Please find the attached Data sheet for reference .
Thanks & Regards
Shekar
 
					
				
		
 ahaahaaha
		
			ahaahaaha
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Shekar,
It can be, when loading data, to create a composite field like this
LOAD
...
Financial_Yr&'|'&Month as KeyData
From...
Regards,
Andrey
 
					
				
		
 ahaahaaha
		
			ahaahaaha
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Shekar,
It can be, when loading data, to create a composite field like this
LOAD
...
Financial_Yr&'|'&Month as KeyData
From...
Regards,
Andrey
