Join tables with out identical fields

[nareshthavidishetty]

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..

[sunny_talwar]

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

[swuehl]

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?

[nareshthavidishetty]

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

[nareshthavidishetty]

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);

[swuehl]

Try to rename the field in the second table:

LOAD LOCATION as location,

     Market

FROM

(ooxml, embedded labels, table is Sheet1);

[nareshthavidishetty]

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..

[tyagishaila]

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.