Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Match values in a column with itself

Hi All,   I have a table with few columns. I want match fields in one column to match with itself and generate output. I can do it easily in Access by creating a copy of table and joining the respe...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

amitchandak : It doesn't seems to work. The two tables in the screenshot are identical tables. I just created a copy of one of the tables.  

Yes/No is based on where:

Merchant_Number = Merchant_Number(from 2nd table)

and

date = date(from 2nd table)

and

account_user_id = account_user_id(from 2nd table)

 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , new column in table 2

if(countx(filter(Table, Table[merchant_id] =(Table2[merchant_id]) && Table[Day] =(Table2[Day]) && Table[user_account_id] = (Table2[user_account_id])),Table[id])+0 >1,"Yes","No")

 

Refer the way to move value from one table to another https://www.youtube.com/watch?v=czNHt7UXIe8

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    amitchandak : Can you help me in understanding the purpose of Table[id])+0 >1? The id is just some random nos.