Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Custom Column Creation help

Hi,   Can any one please help me on below issue. I have an Input table like below. Input Table: WONum      Assoc. Work Order number 7609450       7605060 7605060       7167140   ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    I am a bit confused, but please check the below picture and the attached pbix file whether it suits your requirement.

     

     

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

Hi,

I am a bit confused, but please check the below picture and the attached pbix file whether it suits your requirement.

 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Jihwan_Kim 

Sorry the above one is not working. Please can you see the below Input and expected output. Currently the above two expressions working as individual but need L3 and L4 solution in one expression. In some cases have L3 is max in some cases have L4 is max.

Logic is 

L1 = if WO is not in associate wo
L2 = check L1 against WO and find associat WO 
L3 = check L2 against WO and find assocuate WO
L4= do for L3 again

loop will continue until it doesn't find next value