Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

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
‎03-18-2021 12:15 PM

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?

Labels:
Reply
0 Likes
2 REPLIES 2
ChrisTX
16 - Nebula
16 - Nebula
‎03-18-2021 12:29 PM

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

 

Reply
HW1
9 - Comet
‎03-18-2021 05:26 PM

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.

Reply
0 Likes
GenAI Contest Form
License admin COmmunity Live
Labels
Top Solution Authors
View All