Skip to main content
To homepage To homepage
Question

REST Data source - How to set replace value in Table builder?

anders.e.jonsson
Contributor
Forum|alt.badge.img+1

Hi,

I’m trying to use the transformation Set replace value in the Table Builder. Described in tutorial 

like this:
 

I tried a simple SQL string function (LEFT(NodeName,5). It looks proper in the XSLT Output:
 

The execution worked fine. No errors. But both columns PatientNameHash and PatientName produces the same result in the Ingest table. The full name.

Anyone who knows how to format a transformation in Set replace value?
Is the content of the template “string-replace-all” available for viewing?

BR
Anders

Anders

2 replies

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Thomas Lind
  • Community Manager
  • 1020 replies
  • March 20, 2025

Hi ​@anders.e.jonsson 

I just did a quick google on XLST functions and found this.

fn:substring(string,start,len)
fn:substring(string,start)		 Returns the substring from the start position to the specified length. Index of the first character is 1. If length is omitted it returns the substring from the start position to the end

Example: substring('Beatles',1,4)
Result: 'Beat'

Example: substring('Beatles',2)
Result: 'eatles'

I don’t know exactly how it works, but it seems to me that this could be an option to do something like this.

anders.e.jonsson
Contributor
Forum|alt.badge.img+1

Hi ​@Thomas Lind ,

Thanks, but that made no difference. 

At what stage is the transformation performed?
What I really want to do is to hash sensitive data.

BR
Anders

Anders

Reply


Related topics

Most helpful members this week

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings