Applications for the Community Advisor Program Class of 2025 are NOW OPEN – Apply Today!
SOLVED
Add 04 spaces when matching records on Update activity?
My recipients codinternocomputacional has 04 white leading spaces for each value.
My other source CSV's "customer_cic" , which is the key to make the match, has no leading white spaces. I cannot/should modify recipients. How can I add the 04 when doing the key matching?
Topics
Topics help categorize Community content and increase your ability to discover relevant content.
1 Accepted Solution
Correct answer by
Hi @god_prophet ,
In Update data activity > Identifier > edit expression > Advanced selection > Edit the formula using an expression > concatenate customer_cic with the prefix you need to add.. Example,
'04'+customer_cic(from File)
Result,
It will append 04 to the input value.
If you want to add 4 white spaces instead of 04, same you can use below expression and replace 04 and type 4 spaces in it as below,
' '+customer_cic(from File)
Correct answer by
Hi @god_prophet ,
In Update data activity > Identifier > edit expression > Advanced selection > Edit the formula using an expression > concatenate customer_cic with the prefix you need to add.. Example,
'04'+customer_cic(from File)
Result,
It will append 04 to the input value.
If you want to add 4 white spaces instead of 04, same you can use below expression and replace 04 and type 4 spaces in it as below,
' '+customer_cic(from File)
Related Conversations
