Dynamic Replace with Dynamic Input: Excel+Oracle

timewaste

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	...	...	...

@JoshKushner

What I have been using in the workflow:

JoshKushner

This is an instance where. You want to use a join tool to merge the two data sets.

Excel into Left.
Oracle into Right.

Join by Specific Records:
Left: Data Value
Right: Data Value

Then just uncheck both Data Value fields in the join tool container