Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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