This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have two separate files and each contains a column that I would like to compare. What I would like to do is check to see if each value from the column in file A exists in the column in file B and if so, to return an output like "exists in file B".
My initial attempt was to use the Alteryx formula tool and write an if statement like:
If [file_a_column_name] exists in [file_b_column_name] then "exists in file b" else "does not exist in file b" endif
However, it is not allowing me to connect both files into the input anchor of the formula tool.
Is there a way for me to compare the columns from these two files?