Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 Jacob
		
			Jacob
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		HI All,
I am new to QlikView. Please help
I have two tables and i want combine all filed and create a 3rd table.
I don't have a primary key.
T1
| COUNTRY | 
| ind | 
| uk | 
| us | 
| aus | 
T2
| SALES | 
| 10 | 
| 20 | 
| 30 | 
| 40 | 
T2
| Qty | 
| 1 | 
| 2 | 
| 3 | 
| 4 | 
I have to create a 3rd table and I want to combine all filed .
| COUNTRY | SALES | Qty | 
| ind | 10 | 1 | 
| uk | 20 | 2 | 
| us | 30 | 3 | 
| aus | 40 | 4 | 
 dplr-rn
		
			dplr-rn
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		 
					
				
		
 miguelbraga
		
			miguelbraga
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hey there,
The only concievable way to achieve this is doing a script like this one:
T1:
LOAD *,
RowNo() as Id
;
LOAD * INLINE [
COUNTRY
ind
uk
us
aus
];
left join
//T2:
LOAD *,
RowNo() as Id
;
LOAD * INLINE [
SALES
10
20
30
40
];
left join
//T3:
LOAD *,
RowNo() as Id
;
LOAD * INLINE [
Qty
1
2
3
4
];
Drop Field Id from T1;
RENAME Table T1 to Table;
See the final result:
See the attached file.
Best regards,
MB
