Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Alteryx Input Not Bringing in All Columns

mattpeltcfa
7 - Meteor

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?

2 REPLIES 2
ChrisTX
15 - Aurora

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

 

HW1
9 - Comet

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.

Labels