Due to chemo brain, I've lost my ability to think and create what should be a simple workflow. I need to move old data from a template that use to have 2 identifying numbers to a new template that has 1. The fields may each have a value or only 1 has a value. The primary number of the 2 fields always takes precedence. If, however, there isn't a primary number the secondary number should be used. I have been staring at this for hours and getting nowhere. Any help would be appreciated.
Question
Question
Replies
replied on March 30
Single-value fields? I would try a Token Calculator activity with an IF expression like this:
where Field Token 1 stands in for the Primary number field and Field Token 2 is for the second one. With a Retrieve Field Values before Token Calculator to get them from the doc. If you're running a search to get documents to process, add the fields as properties to retrieve with the document in Search Repository activity.
Best wishes and speedy recovery!
1
0
You are not allowed to follow up in this post.