Impact 2024: The Industrial Data and AI Conference for and by Users | Nominate Speakers Now for a Ch...
Executing a SQL Transform joining 2 tables from Raw and writing results to a 3rd Raw table.Perhaps there is a syntax issue? Not sure if it matters but I noticed the error msg omits some backticks like here:'ChemPlant.`Alarms-2-INActive`.EventAssociationID' there is no backtick before Event… Thank you.SELECT `ChemPlant`.`Alarms-2-INActive`.`EventID`, `ChemPlant`.`Alarms-2-INActive`.`SourceName`, `ChemPlant`.`Alarms-1-Active`.`EventTimeStamp`, `ChemPlant`.`Alarms-2-INActive`.`EventTimeStamp` AS AlarmOffTime, `ChemPlant`.`Alarms-2-INActive`.`Message`, `ChemPlant`.`Alarms-2-INActive`.`Active`, `ChemPlant`.`Alarms-2-INActive`.`EventAssociationID` as key, `ChemPlant`.`Alarms-2-INActive`.`EventAssociationID`FROM `ChemPlant`.`Alarms-2-INActive` INNER JOIN `ChemPlant`.`Alarms-1-Active` ON `ChemPlant`.`Alarms-2-INActive`.`EventAssociationID` = `ChemPlant`.`Alarms-1-Active`.`EventAssociationID`Error Message:Cannot resolve 'ChemPlant.`Alarm
Hi, Since the relationship have been created between types in the data model. I am wondering why it can’t be made at the backend by CDF but required user to make the relationship transformation manually ? Is it by design ? Thanks, Kind regards, Carrie
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.