Community Halloween is live until October 31st! Complete any 2 quick activities to earn the 2025 Community Halloween badge. Feeling brave? Check out the activities here
Start Free Trial

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Field Mapping data that doesn't start on the first row

michalikm
8 - Asteroid

Hello!

 

I have an input data tool that is modeled off a report where the data starts on row 9. When the user browses to this file, it's possible there will be additional/unnecessary columns of data, so I'd like to use field mapping. My question is, is it possible using a file browse and action tool, connected to that input data tool, to allow field mapping that starts on the 9th row of the user input (like it does on the input data tool)? 

2 REPLIES 2
MinhLO
7 - Meteor

Hey @michalikm 

Not sure if I understood properly your use case.

- You want to field map an excel file

- However data starts on line 9

 

If that's the case, you can do the following:

MinhLO_0-1761840744437.png

and configure the input data as follow:

MinhLO_1-1761840776355.png

I get the following:

MinhLO_2-1761840794517.png

With this initial test data

MinhLO_3-1761840819894.png




By the way, this question should be in the Designer topic :)

Let me know if it helps!

MinhLO
7 - Meteor

Solution attached @michalikm