Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 HKN1
		
			HKN1
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I am trying to generate a generic date by concatenating the dates. But the amount totals, or quantity totals do not give the correct date.
I have tried every way (Link Table, concat table, fact table, calender table...), but without success.
There should be only 1 date instead of creadet_date and publish_date.
Can you help me?
Thank you.
 QFabian
		
			QFabian
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi @HKN1 , one option is keep the tables renaming fields :
Here the example script :
:
 QFabian
		
			QFabian
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi again @HKN1 , another option is concatenating :
 HKN1
		
			HKN1
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		does not work.
I do not get an error, but the total units that should be are incorrect.
Is there another way to do common times?
Thanks.
