Forum Discussion

DavidB023's avatar
DavidB023
Helper III
8 years ago

If with two column

 

Hi everybody !

 

I want to create an if function between two tables.

 

In fact, if I have nothing in a specific column in my second table, my personalize column (my function) take the number 3.

 

I try with contain but unsuccessful.

 

Here is my example : Table 1

 

 Table 2

 

 

 My two tables have same rows.

Thanks

Best regards

David

Need Help

1 Reply

  • quentin_vigne's avatar
    quentin_vigne
    Solution Sage
    8 years ago

    Hi DavidB023

     

    You can simply use = or <> with LEFT() or RIGHT()

     

    For example your date is 01/01/2018 and you want to verify if it contains 2018 type :

     

    Column = IF(RIGHT(Table[DateColumn];4)="2018";0;3)

     

    Hope this help

     

    - Quentin