Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hi
I need help with a project I'm busy with. There's about 5 tables I have to concatenate to create one full database.
The problem that occurred is whenever i'm finished running the scripts, theres one particular field that wont appear. That field is important as it gives a specific description of the ongoing fields and tables.
 
					
				
		
 MarcoWedel
		
			MarcoWedel
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hard to tell without knowing your tables and script.
Maybe this helps:
Qlik Community Tip: Posting Successful Discussion Threads
How to get answers to your post?
Its not about the answer, rather it’s about the question…
regards
Marco
 
					
				
		
 Sokkorn
		
			Sokkorn
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Ervin,
I would suggest to check in your script is there any "DROP Field" keyword. Moreover, you may check if the field exist in your database.
Can you share your load script?
Sokkorn
 madhumitha
		
			madhumitha
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hello Ervin,
Are you force concatenating or Auto concatenating?
There is a good possibility that you miss a table itself if you auto concatenate without matching fields.
Try using debug/exist script in loading steps and find out where exactly you are dropping the field.
Also please post your script so that we can have a clear idea.
Thanks!
 
					
				
		
 mithilesh17
		
			mithilesh17
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Dear Ervin,
It seems you are not taking that particular field in your load script. Do check that first!
Regards,
