Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hi,
I have two tables (Table A and Table B) that I want to combine in qlikview. Both tables have exactly the same fields in them except table A has one extra field. How can I add this field to Table B in the load script so that they can be loaded as one table
 
					
				
		
 swuehl
		
			swuehl
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Nickh123,
you can use
Concatenate LOAD ...
to force qlikview to combine both tables.
Hope this helps,
Stefan
 
					
				
		
hi,
Load table A and concatenate table B with it under a flag name
ex:
AB:
laod table A
concatenate
tableB
 
					
				
		
 rahulgupta
		
			rahulgupta
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hey Hi,
Solution to your problem:
Lets take a scenario where tableA has three fields(Field1,Field2,Field3) and tableB has only 2 fields
(Field1,Field2), then we add a new field as follows which automatically concatenate the two tables:FinalTable:
Load
Field1,
Field2,
Field3
from TableA;
Load
Field1,
Field2,
'' as Field3
from TableB;
Hope this helps
Regards
