My Alteryx input for a few different CSV files only brings in 5 of the 8 columns that have data. 3 of the 8, located to the right, do not have data in the first cell (the header), but data 15-20 cells below. How can I pull all this data in?
In the Input Data tool un-check the option for First Row Contains Field Names
Then use the Dynamic Rename tool to Take Field Names from First Row of Data
Chris
Can you share the csv for replicating the problem?
In the input tool, you have an option to select of the first row contains headers. Uncheck that and use the dynamic rename tool to select the row that has headers.