I am trying to create a workflow to compare two input files for changes to a record. Input file 1 is a table from existing process representing current state. Input file 2 is an updated matrix. The workflow should take the input as presented in the attached workflow, make the comparison and output results in same format as input. My initial thought is to determine the hierarchy within the Category field creating a table with cat1, cat2, cat3...to root. This would create records with like fields to compare. The final process would be to reverse to generate the output file. I'm sure there is a more efficient way to perform the task described. Any help is appreciated.
