Modeling

[#1]

I Have 4 Table

The column name of all the excel sheets are as follow with table name .Can someone tell me during modelling what technique do i need to use , do need to go for Concatenate , join ?

Help will be really appreciated

Factory:

Product_ID

Product

Price

Vat

Location

Department:

Product_ID

Product

Price

Vat

Department

LOB

Billing:

Department

Product_ID

Product

Price

DIm

Land

Stores:

Department

Store_ID

Product

Price

Location

[sunny_talwar]

Won't be 100% certain before seeing the actual data, but I think you need to use a Join here.

[alexandros17]

Rename Price and Vat fields in all the tables (so each table have a different field name for Price and VAT, then load as is, everithing will be associated ...

let me know

[gautik92 · Accepted solution]

you can use join instead concatenate

[Marcoimp]

In "Stores" table, you have the description of product (Product), but not the ID (Product_ID) why?

Why you hold product name (Product) in every table?

[Marcoimp]

You have 3 problems (!!):

1) Duplication of field names (like "Price")

2) Duplication of field (like "Product")

3) You have to choose the position of product_id (to get the product description, that I hold in just one table)

This is my answer:

BUT:

You heve to create some AutoNumberHash128 key linking Department and Product_ID

then you have to choose which table must hold the product_id in order to link factory table (I choose Billing in my view but I'm not sure is the right position)...

[qlikviewwizard]

Hi,

Can you attach some sample data?