Hello Peers,
I have a scenario where I would like to replace existing data values into data IDs. The data values come from an excel sheet and data IDs (along with data values come from oracle). How can I use Dynamic Replace to achieve that? TIA!
Source 1 (Excel):
Data Value | Col 2 | Col 3 | ... | ... | ... |
ABC | 20 | 30 | ... | ... | ... |
CDE | 10 | 34 | ... | ... | ... |
EFG | 23 | 45 | ... | ... | ... |
GHI | 25 | 56 | ... | ... | ... |
Source 2 (Oracle Table):
Data ID | Data Value |
1 | ABC |
2 | CDE |
3 | EFG |
4 | GHI |
Now, the output should be:
Data Value | Col 2 | Col 3 | ... | ... | ... |
1 | 20 | 30 | ... | ... | ... |
2 | 10 | 34 | ... | ... | ... |
3 | 23 | 45 | ... | ... | ... |
4 | 25 | 56 | ... | ... | ... |
What I have been using in the workflow:
Solved! Go to Solution.
Hi @timewaste
Thanks for your question! I believe the easiest solution would be to use the 'Find and Replace' tool which can be found in the 'Join' tool category. I've attached an example using the sample data mentioned.
If you have any other questions, I'd be happy to help!
Amelia
Ya, I could do as Josh suggested. My workflow below:
@JoshKushner
Oh sure, will keep that in mind.
But, a little twist to my question leads to another question which is, how can I use this output column to append in another workflow? Is it possible?
Thanks!