Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
JSey
Creator
Creator

Convert Salesforce record ID to a number?

Hi

For case feed (these essentially are the chatter comments on a case record), I need to export the record ID as a number ID into another system. However, Salesforce ID are letters and numbers that are also case sensitive. Is there a java script transformation code I can use to only convert the last 10 characters from the Salesforce ID into a numberic code?

PS. I cannot create autonumber field in Salesforce on Case Feed as we are not allow to create custom fields on case comment.

Labels (3)
1 Reply
manodwhb
Champion II
Champion II

@Johnny Sey​ , you can try to use the below expression in tMap to take last 10 characters of string and convert it into integer.

 

Integer.parseInt(row1.col.substring(row1.col.length()-10)) 

 

0693p000009p6SfAAI.png

 

Thanks,

Manohar