Hello all, I was wondering if it is possible in Alteryx to have it read an excel file and search for a certain term. If that term is in the excel file I would like it to edit another excel file to reflect this.
Without seeing the format of the two files it's a little tough to give an exact solution, but in a short answer yes.
Both files would be read in, test would be performed to determine if the first file contains the value or not, then the second file can be manipulated and output in the same workflow if needed, or left alone.
Hope this helps
Thank you for the assistance, which tools specifically would I use for this?
Thank you for the assistance, which tools specifically would I use for this?