topic Re: Data modelling in QlikView

Data modelling

Sun, 29 Jun 2014 12:54:02 GMT

Hi All,

I have 4 tables Tab1, Tab2, Tab3, Tab4. In all my 4 tables i have a,b,c,d common fields.

Again in Tab1 and Tab2 i have e,f,g as common fields and in Tab2, Tab3 i have h,i as common fields.

i'm unable to do data modelling for this, could you please help me on this

Tab1	Tab 2	Tab3	HTab4
a	a	a	a
b	b	b	b
c	c	c	c
d	d	d	d
e	e	h	z
f	f	i	p
g	g	y
h	k
u	l
v	h
w

Thanks,

Vamsi

Re: Data modelling

ashfaq_haseeb — Sun, 29 Jun 2014 12:58:39 GMT

Reddy could you be more clear, What are you trying to achieve here.

what is your expected output with some sample data.

Regards

ASHFAQ

Re: Data modelling

eduardo_sommer — Sun, 29 Jun 2014 13:01:45 GMT

One possible solution is to create a field called Table, with values 1 to 4, representing rhe original table and have the four tables concatenated. The fields that aren't part of an individual table will have null as value.

Eduardo

Re: Re: Data modelling

Sun, 29 Jun 2014 13:44:54 GMT

Hi Mohammad,

Please find the sample QVW and Excel file and give some suggestion on Data modelling.

For A, B, C fields in all tables we can create field concatenation or link table, is it correct?

Thanks,

Re: Re: Re: Data modelling

ashfaq_haseeb — Sun, 29 Jun 2014 13:50:00 GMT

Hi,

It really depends on what are you trying to achieve.

One of the possibility, look at the below code.

LOAD A,

SALES,

1 as FLAG

FROM

Sample.xlsx

(ooxml, embedded labels, table is Sheet1);

Concatenate

LOAD A,

[RESPONSE COUNT],

2 as FLAG

FROM

Sample.xlsx

(ooxml, embedded labels, table is Sheet2);

Concatenate

LOAD A,

[AVG SALES],

3 as FLAG

FROM

Sample.xlsx

(ooxml, embedded labels, table is Sheet3);

Regards

ASHFAQ