Constant Data changes interrupts Mapping table:

[RINIT]

Can anyone help me how to solve a data that keeps on changing, I have a mapping table in my workflow where I say if in 1 file data a particular id comes e.g.: RED then replace this ID with the other data e.g. Apple from other data source. Based on this matching I am finding common on both data and joining items, but this logic fails when the data changes in 1 particular file e.g. RED and other file has Car, even though the name changes in 2nd file but this should get matched with the Red from the first file.

File 1	File 2
Red	Apple
Red	Car

Due to constant changes in file my workflow gets disturbed and again I have to manually map it by deleting the 1 st scenario match and update using second File.

Thankyou.

[jrlindem]

Can you provide the before and after examples?  I think i'm following what you're saying.  If your mapping or crosswalk table has multiple return options like "Apple" and "Car" then only one of those is going to return if you use FIND REPLACE tool.

If you have the same scenario using the JOIN tool, then you're going to get "Apple" and "Car" back for every initial value of "Red" from your File_1, etc.

So it would be helpful to know what your source data is and what your expectations are.  Can you attach example files that have fake data?