Hello!
I am running a workflow that pulls info from multiple files in a folder and consolidates this information into one new Excel file. The columns are all the same; however, two of the columns are sometimes entered as text and sometimes entered as numbers, so Alteryx is recognizing the data as having "different schemas" in Excel. My goal is for the workflow to pull all of this info, regardless if they are text or number. It doesn't seem to do this, as every time I run the workflow it only pulls the data that matches the first file in the folder (text instead of number). Is there a way to change the input data to all be text before it is read by Alteryx for my output? I know you can change it once it is input, but my problem lies in that Alteryx isn't pulling all of the data in the first place.
Any help would be greatly appreciated! Thank you!
