Forum Discussion

marabeda's avatar
marabeda
Icon for Helper I rankHelper I
4 years ago
Solved

Create a calculated columns from 2 tables

Dear Community, I have these 2 tables: Table1 Table2 The relationship between tables is many-to-many with column Client My objective is to have two calculated columns in Table1 where ...
marabeda's avatar
marabeda
Icon for Helper I rankHelper I
4 years ago

Hi, thank you for your reply, appreciated, but probably I was not so clear.

What I need to know in Table1 is: 

1) Is the client in Table1[clienti]=Table2[clienti] if the answer is yes then

2) Is  Table1[giorni]=Table2[giorni in numeri]? If the answer is yes, then is OK.

My aim is to be sure that my client has the job done exactly at the right day of the week.

Thank you again

 

technolog's avatar
technolog
Icon for Super User rankSuper User
4 years ago

marabeda Do you mean something like this in results?

 

  • marabeda's avatar
    marabeda
    Icon for Helper I rankHelper I
    4 years ago

    Hi Technolog, yes is correct. Now I try your solution on my original table to check if it works and I let you know.

    I am gratefull for you prompt replay.

    Marabeda

      • marabeda's avatar
        marabeda
        Icon for Helper I rankHelper I
        4 years ago

        Hi technolog, it works! thank you. I solved first part of the question. The second part is how to show the value in table2[ore] in a column that match client in table1. Can you help? Can I write the same formula?

        Many Thx