topic Re: Join tables with out identical fields in QlikView

Join tables with out identical fields

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

We were having two tables one gives product data and another gives geography data,but there were no common fields between these tables.

Here we need to show geography level product sales.How?

Thanks..

Re: Join tables with out identical fields

sunny_talwar — Tue, 22 Mar 2016 09:58:15 GMT

If there are no common fields what is the association between the two tables? You will end up having a Cartesian product

Re: Join tables with out identical fields

swuehl — Tue, 22 Mar 2016 10:00:21 GMT

Not sure if I understand.

There are no common field names (then maybe just rename using AS), or there are no semantically common fields at all?

How would you then like to relate the tables?

Could you post some sample record lines for both tables?

Re: Join tables with out identical fields

nareshthavidishetty — Tue, 22 Mar 2016 10:00:33 GMT

I have tried with left join but it ran for much time means the script not responding

Re: Join tables with out identical fields

nareshthavidishetty — Tue, 22 Mar 2016 10:04:26 GMT

Hi, Below is the script

LOAD model_number,

quantity,

amount,

code_product_category,

description_prod_cat,

description_model,

location,

new_order_date

FROM

(qvd)where not match (description_prod_cat,'NON-INVENTORY','TO BE REASSIGNED');

//Left Join(QV_top25_Product_Last_Purchased)

LOAD LOCATION,

Market

FROM

(ooxml, embedded labels, table is Sheet1);

Re: Join tables with out identical fields

swuehl — Tue, 22 Mar 2016 10:07:56 GMT

Try to rename the field in the second table:

LOAD LOCATION as location,

Market

FROM

(ooxml, embedded labels, table is Sheet1);

Re: Join tables with out identical fields

nareshthavidishetty — Tue, 22 Mar 2016 10:11:10 GMT

Hi,

I have checked there is an field with name location table 'A' then we associate the table'B' with table'A'.

Issue got resolved.

Thanks..

Re: Join tables with out identical fields

tyagishaila — Tue, 22 Mar 2016 10:28:32 GMT

It may be possible both tables have no common field name.

but there must be some criteria to associate both tables.

to find out

geography level product sales.