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?
解決済! 解決策の投稿を見る。
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