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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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