You are viewing limited content. For full access, please sign in.

Question

Question

Run Capture Concatenation

Capture Profiles Workflow
Updated September 17
asked on November 26, 2024

This is the field that I'm working with

 

When I do a Capture on it, it makes two values. I need to combine them into one metadata field value in a workflow. 

 

I tried doing a for each but it'll just replace the existing value instead of appending the second value to the end. 

 

Any ideas on how to do this?

0 0

Replies

replied on November 26, 2024

Use an Assign Token Values activity to create a new token to hold the combined value.  If it's always just two values, you can do that easily using the Token Editor to access the first "index" (the first value) of the multivalued token and the second index of multivalued token.  Something like:

%(CustomerPO#[1]#)%(CustomerPO#[2]#)





If you have multiple values that all need to be combined, that can be done similarly with Assign Token Values, but also needs a For Each Value activity to concatenate each value, in turn, to the new token.

0 0
replied on September 17

Another tip - we had a similar situation with a two line field where the output seemed to have a CR in the middle.  In the WF designer, the output looked like this:

 

[Name] Trust, John & Mary

 

Smith Trustees 

 

With that big space in the middle. When I added the value to a field, it complained that the value was blank.  When I added the value to a token with a trim function first, it liked it just fine.

 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...