Skip to main content
Answer

TimeSeries Transformation

  • June 24, 2024
  • 3 replies
  • 50 views

Forum|alt.badge.img+5

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
Seasoned Practitioner
Forum|alt.badge.img+2

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
Committed

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
Seasoned Practitioner
Forum|alt.badge.img+2
  • Seasoned Practitioner
  • Answer
  • 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.