0

I'm new to Azure Data Explorer and working with Salesforce data. A very common data cleansing is to check the Salesforce Account Id is 18 character long. I know how to transform the id in MSSQL but not sure how to build the same function or script in Azure Data Explorer. I need a similar solution to this to this in Azure Data Explorer.

Has anyone tried standardizing Salesforce Id that are 15 character in Azure Data Explorer?

Skin
  • 9,085
  • 2
  • 13
  • 29
SusanD
  • 143
  • 9

1 Answers1

0

There's no built in function for this in KQL. You'll need to write your own.

Slavik N
  • 4,705
  • 17
  • 23