Forum Discussion

hanyfouda2023's avatar
hanyfouda2023
Icon for Helper II rankHelper II
2 years ago
Solved

Duplicated values

Hello all , I'm working in a sheet must be including duplicates values " We have set numbers of venfing machines from time to time we change its locations but serial number keeps the same only locat...
Need Help
  • Fowmy's avatar
    Fowmy
    2 years ago

    Hi hanyfouda2023 

    You need to have a master and transaction tables and create a relationship. Master Table you will have the machines and it will be unique then the transaction table will have the machine IDs with their location trasnfer, from date, to date etc.

    Hop this is clear?

     

jayppatel07's avatar
jayppatel07
Frequent Visitor
2 years ago

Hi
what problem are you trying to solve in the report?
can you please explain it with example or if you can share more details that'll be helpful
are you facing issue with establishing relationship with another table ?
from these two rows it seems like only serial# is duplicate not the rows.

Thanks