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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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