Multiple criteria mapping table to assign value
Hello,
I’m currently attempting to construct a workflow that uses a mapping table with 5 columns of criteria that assigns a categorical value to raw data. The biggest caveat is that within some rows, the criteria value does not matter. Additionally, there is a numeric column within the raw data that must be retained. I’ve attached a sample workflow with a mapping file table and raw data.
I’ve experimented with a few ways of how to tackle this problem, but haven’t yet found a solution. As I mentioned, the mapping table is unique in which criteria indicated with an “*” means that the raw data value can be anything. Additionally there is a “fallback” assignment of “Z” that captures any rows where there isn’t a mapped assignment.
Hopefully I explained the problem well enough to understand. Also within the attached workflow is a sample desired table of how I want the end result to be.
Thanks in advance for any help or suggestions, John