@Stig Harald Gustavsen thanks but I found my answer. I thought the OID was sort of the foundation of the CDF, but I was wrong. OID is just a way Aker and Cognite uses to share data for research purposes.This link gave me more detailed information about it. cognite_co_konsus_25291_v05 (hubspotusercontent10.net)
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.
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 assetIDFROM IFSDB.sensors as sensorsleft join _cdf.assets as assetsON assets.name = REPLACE(RIGHT(LEFT(tag, 15), 11), '_','-')and assets.id != 0 and assets.id is not nullwhere externalId LIKE 'Eber1977&'
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.