Error using Timeseries and events not going to the correct dataset.

Did you associate the timeseries to the dataset in the code of the transformation? 

The dataset of the transformation could be different to the dataset of the objects you are transforming in your transformation code.

Can you share your transformation code? 

Yes. Indeed associated the TS to the correct Dataset.

Sure.. here it is the code.. 

SELECT 
 
tag AS name, 
concat('Eber1977:',tag) AS externalId, 
to_metadata(*) AS metadata, 
info AS description,

bigint(assets.id) as assetID
FROM IFSDB.sensors as sensors
left join _cdf.assets as assets
ON assets.name = REPLACE(RIGHT(LEFT(tag, 15), 11), '_','-')
and assets.id != 0 and assets.id is not null
where externalId LIKE 'Eber1977&'

If you want to update the timeseries and assign them to a different dataset, you can add this line

(replacing 1234556 with the dataSetId of your dataset)

1234556 as dataSetId,

Hi @eberribeiro 

In which cdf project are you working? If you are not sure, could you paste the url?
I was looking for your work in our academy cdf projects but no luck finding it. 

Sofie

Hi Gaetan, good to know that there is a way to change dataset once it has been wrongfully assigned. Thanks.

Hi Sofie, since it did not affect my training and I was able to follow the instructions to obtain the required information using only one data set, I completed the training and, as per the instructions at the end, I cleaned up all my data. That's why you couldn't find any of my info but still don't know what really happened. How it ended up on the wrong dataset, even if the information shows the opposite.