Forum Discussion

schoden's avatar
schoden
Post Partisan
5 years ago
Solved

IF with text value & AND OPERATOR

Hi All,    Has anyone faced same problem like mine.  I am making new column with IF statement for text value column with condition of AND OPERATOR.  Although there exist data in dataset , the IF c...
Need Help
  • schoden's avatar
    schoden
    5 years ago

    Hi All,

    I am posting for others reference as the issue with AND operator is if it is to compare two different columns it works fine but when is to compare two values from same column the AND operator or IN operator doesnt work.

    In such case you have to use nested IF.

    Cheers.

schoden's avatar
schoden
Post Partisan
5 years ago

Hi All,

I am posting for others reference as the issue with AND operator is if it is to compare two different columns it works fine but when is to compare two values from same column the AND operator or IN operator doesnt work.

In such case you have to use nested IF.

Cheers.

schoden's avatar
schoden
Post Partisan
5 years ago

Hi All , 

 

I thought I will share the best solution I found for my issue stated above.  It  works for any issue like one customers purchasing Product A and Product B ..Pretty much like What I was after.

 

After severel internet search, I found an article on Basket Analysis and a video tutorial : 

https://www.youtube.com/watch?v=8PUNpVAiRAE 

 

Cheers, 

Have a good day.