Linking data from 2 fields in the same table

[davyqliks]

Hi All,

In my data model i have a table with the following:

in the load please can someone try to explain how i can make a link so that

wys01 data is related to Upper 1 weight Ratio data

wys02 data is related to Upper 2 weight Ratio data

I will then hope to have all wsy01 - wsy06 loaded as "Fibre" and the Weight Ratios loaded as "Ratio" and achieve a table like below where

But

Cork Leather                     = 40

Plastic Recycled (PET) = 20

Wool (RWS)                       = 20

Leather Recycled            = 20

I tried like this:

If(Len(wys01) >0, [Upper 1 weight Ratio]) as Ratio

but this is not working as i would hope.

Thank you for any suggestions

Daniel

[Chanty4u · Accepted solution]

try this

If(Len(wys01) >0, [Upper 1 weight Ratio],[Upper 1 weight Ratio]) as Ratio