topic Re: Combine 2 table filed and create 3th table in QlikView

Combine 2 table filed and create 3th table

Jacob — Thu, 10 Jan 2019 16:42:19 GMT

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.

COUNTRY

ind

aus

SALES

Qty

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

Re: Combine 2 table filed and create 3th table

dplr-rn — Thu, 10 Jan 2019 16:46:10 GMT

Without primary key i think will be difficult to do withing qlik . how will qlik know Sale of 10 and quantity of 1 is associated with country ind

Whats your data source? why not do this there

Re: Combine 2 table filed and create 3th table

miguelbraga — Thu, 10 Jan 2019 17:40:41 GMT

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,