I have a simple workflow where I am comparing one file to another file in order to see the changes that were made between the two files. Alteryx is only picking up the records where there is a match on the primary key. I want the output to show me all the changes, even if there is no match on the primary key. What do I need to do to fix this. Here is a snapshot of my workflow. Is there a formula I can add that will show all primary key fields even if they do not all exist in the new file or vice versa?
Solved! Go to Solution.
Actually, the only records I am interested in seeing are those records where there is not a match between the amounts associated with the PO; including when a PO number/value exist in one file and not the other. My current workflow shows all the records where there a match between the PO numbers and then calculates the difference between the values of each PO. I don't need to see the POs where these is a match between the PO amount in one file and the PO amount in the other file. I only want to see the PO number and its values when a match does not exist in the two comparison files. That could be if there is a match between the PO numbers but the values are different or a PO exists in one file and has a value and the PO does not exist at all in the other file. I want to see all of those.
@binuacs I was able to get it to work using this latest diagram. Thank you very much. This is what my workflow looks like now:
@pderwa12 good to know that you figured it out