Skip to main content
M
Committed ⭐️⭐️
Mayuri Bhoge
Committed ⭐️⭐️
June 24, 2024
Solved

TimeSeries Transformation

  • June 24, 2024
  • 3 replies
  • 71 views

Hello Team, 

I want to link the assets with existing timeseries. It does not have any column in common. I have added the timeseries name in metadata of assets. Is there a way to link the assets with timeseries?

My assets table has below columns.

Tagname column has its related timeseries names.

 

Best answer by Dilini Fernando

Hi @Mayuri Bhoge,

I hope the above has been helpful. I will now close this thread. If you have more questions, please feel free to post in Hub.

3 replies

Dilini Fernando
Expert ⭐️⭐️⭐️⭐️
Dilini Fernando
Expert ⭐️⭐️⭐️⭐️
June 24, 2024

Hi @Mayuri Bhoge,

The time series can be associated with assets. Please refer to our documentation. If you have any further questions, feel free to respond to this thread. 

    APSHANKAR Sagar
    Seasoned ⭐️⭐️
    APSHANKAR Sagar
    Seasoned ⭐️⭐️
    June 27, 2024

    It looks like the picture you posted is from the header row of a table in a data model. If this is true, you can use pygen to iterate over each row in the table.

    ass_list = pygenclient.assets.list()

    for ass in ass_list:

         name = ass.name

        external_id = exx_ext….

     

    In order to associate an asset with a time series, you can use the SDK client.

    ts = TimeSeries(external_id = ‘XXXX’, unit = ‘YY’, parent_external_id = ‘ZZZZ’)
    client.time_series.upsert(ts)

     

    Dilini Fernando
    Expert ⭐️⭐️⭐️⭐️
    Dilini FernandoAnswer
    Expert ⭐️⭐️⭐️⭐️
    July 8, 2024

    Hi @Mayuri Bhoge,

    I hope the above has been helpful. I will now close this thread. If you have more questions, please feel free to post in Hub.

    Terms & ConditionsAccessibility statement