+1During my training session at Working With CDF: Integrate » Time Series » Working with the IFSDB file I noticed that even though I pointed the Dataset to “FirstNameYearBirth-IFSDB” the data was associated with the other Dataset. The Avevasomething.. how come is that possible? Can someone help me understand what have happened?
The transformation showing the correct Dataset.
The Data Catalog showing that the time series and events went to the wrong data set.
Best answer by eberribeiro
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.
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?
+1Yes. 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,
+7Hi
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
+1Hi 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Check the
documentation
Ask the
Community
Take a look
at
Academy
Cognite
Status
Page
Contact
Cognite Support
