Jump to content

Niranjan

Members
  • Posts

    3
  • Joined

  • Last visited

Posts posted by Niranjan

  1. Thank you 
    If I need to import the data then somehow I need to get the Date or need to prefix some static date like below right:

    Static Date, Sample ID, User Sample Id, Component, Value
    02/16/2022 15:30:01, S-11111, S-11111-PRODUCT, Component1, 0.5
    02/16/2022 15:30:01, S-11112, S-11112-PRODUCT, Component2, 5.5
    02/16/2022 15:30:01, S-11113, S-11113-PRODUCT, Component3, 58
     

    In this case, Is there a way to make Date, Sample ID & Component as unique? So that I will never have a duplicate values.

  2. Thanks for responding,

    The use case is like below:
    We have LIMS (Laboratory Information Management System) data and PI data. PI Data will have timestamp in it and LIMS will have only the Sample Id's, components and their values.

    Example LIMS:
    Sample ID, User Sample Id, Component, Value
    S-11111, S-11111-PRODUCT, Component1, 0.5
    S-11112, S-11112-PRODUCT, Component2, 5.5
    S-11113, S-11113-PRODUCT, Component3, 58

    Example PI:
    Reading Time, Tag, Value
    02/16/2022 15:30:01, Tag1, 0.5
    02/16/2022 15:30:02, Tag2, 1.5
    02/16/2022 15:30:03, Tag3, 5
    02/16/2022 15:30:04, Tag4, 105

    In the above case, We use both data for some custom calculations and get the results & plot the graphs.
    So PI Data i can import to Seeq but not LIMS data as it does not have time stamp.

×
×
  • Create New...