Many to Many relationship

[markgraham123]

Hi,

I have the below data.

When i try to get data in table like,

W2  SUm(Qty)

i get error data when i drill down to SKU....It doesn't show individual SUm() but shows Total() as result in every field...

Can anyone help me

SKU     W1    Qty

1          a          234

2          b          4323

1          c          32

2          d          12

SKU         W2          Location

1          a                    22

2              b          324

1          c          4545

2          d          231

[MK_QSL]

Not clear from you description. Can you provide some more information... possibly what result you are looking for when you select any SKU?

[Kushal_Chawda]

try like this

LOAD *,SKU&W1 as Key Inline [

SKU ,    W1,    Qty

1,          a,          234

2,          b,          4323

1,          c,          32

2 ,         d,         12 ];

LOAD *,SKU1&W2  as Key Inline [

SKU1,         W2 ,         Location

1,          a ,           22

2,          b,           324

1,          c,          4545

2,          d,          231

[markgraham123]

Hi,

But in my original application,

SKUK1&W2 is not unique.

[markgraham123]

Hi Manish,

When i select SKU it should show the respective Sum...for the warehouse and sku.

But it shows the overall total sum.

Please have a look at the application i posted.

[Kushal_Chawda]

Then you need to find the columns(Combination of columns) which uniquely identifies the Row in both the table.

[markgraham123]

THanq Kush..

I'm working on that

[markgraham123]

Hi Kush,

I have thousands of rows after the combination of unique collumns,

Is there nay technique to check whether its unique or not...other than using frequency??

[Kushal_Chawda]

Suppose I have created the Key with combination of fields (A+B+C), so Count of key (Count(key)) should match with number of rows.

[markgraham123]

hi Kush,

Sorry for too many questions...

Count(Key) should match with number of rows????

number of rows of what???

cna u pls lemme knw