topic Re: Modeling in QlikView

Modeling

Mon, 31 Aug 2015 07:25:53 GMT

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

Re: Modeling

sunny_talwar — Mon, 31 Aug 2015 07:34:06 GMT

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

Re: Modeling

alexandros17 — Mon, 31 Aug 2015 07:37:44 GMT

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

Re: Modeling

gautik92 — Mon, 31 Aug 2015 07:46:25 GMT

you can use join instead concatenate

Re: Modeling

Marcoimp — Mon, 31 Aug 2015 07:57:51 GMT

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?

Re: Modeling

Marcoimp — Mon, 31 Aug 2015 08:08:08 GMT

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

Re: Modeling

qlikviewwizard — Mon, 31 Aug 2015 08:38:05 GMT

Hi,

Can you attach some sample data?