Forum Discussion

Anil2264's avatar
Anil2264
Helper I
4 years ago

Triple Logical condition

Hi Team,

 

 I am having a situation where I have to work on triple logical conditions to make a flag as true & false but not able to achieve it. Please refer to the below table & I wanted to have an output column in front of each Material given.

 

MaterialOld SupplierLatest SupplierOutput
1AAA
1LAL
2BKK
3CGG
4DHH
5EII
Need Help
Tips and Tricks

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anil2264 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

    Appreciate your Kudos.

    • Anil2264's avatar
      Anil2264
      Helper I
      4 years ago

      amitchandak My Problem is as below 3 scenarios i am having material column with duplicate records but old supplier names are 2 or 3 with me.
      Now i got new supplier data where my material is having 1 of the 2-3 names of old supplier name & some where it having non existing new supplier name in latest supplier data.
      Please help how i need to bring the output folder as old & new supplier in front of each material. as the sample given above