Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners click HERE | EMEA/APJ Partners click HERE |
06/09/2024 09:25 PM
How to write analytics to rename the accounts in specific endpoints when the status of accounts are "Manually Suspended".
Any example of an analytics query would help.
Thanks & Regards,
SaviyntSavvy
06/09/2024 09:30 PM - edited 06/09/2024 09:32 PM
Select ACCOUNTKEY AS accounts__PRIMARYKEY, concat (name, '-SUSPENDED',' ','on-',current_Timestamp) AS accounts__NAME,'SUSPENDED FROM IMPORT SERVICE' AS accounts__STATUS From accounts Where status in ('Manually Suspended')and endpointkey='5' LIMIT 1; |