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?

     

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
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?

 

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

    Thanks alot it solved the issue