Data modelling

[#1]

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

[ashfaq_haseeb]

Hi

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

what is your expected output with some sample data.

Regards

ASHFAQ

[eduardo_sommer]

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

[#4]

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,

VV

[ashfaq_haseeb]

Hi,

It really depends on what are you trying to achieve.

One of the possibility, look at the below code.

LOAD A, 
     B, 
     C, 
     D, 
     E, 
     SALES,
     1 as FLAG
FROM
Sample.xlsx
(ooxml, embedded labels, table is Sheet1);






Concatenate


LOAD A, 
     B, 
     C, 
     D, 
     E, 
     F, 
     [RESPONSE COUNT],
      2 as FLAG
FROM
Sample.xlsx
(ooxml, embedded labels, table is Sheet2);


Concatenate


LOAD A, 
     B, 
     C, 
     F, 
     [AVG SALES],
      3 as FLAG
FROM
Sample.xlsx
(ooxml, embedded labels, table is Sheet3);

Regards

ASHFAQ