Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Analytic App - Skipping rows to give new header

wonka1234
10 - Fireball

hi,

 

I am trying to skip rows and have my workflow read in the correct rows as headers in the actual workflow.

I do not want to do a chained app.

 

this is the data and I want the headers to be row 6 (header1, header2)

 

wonka1234_0-1686066044626.png

wonka1234_1-1686066055408.png

 

How can I do this within THIS workflow? No chained app allowed.

4 REPLIES 4
FinnCharlton
13 - Pulsar

 

@wonka1234 Sounds like a great use case for a chained app to me, why don't you want to use it?

 

The issue is that the drop-down needs to receive metadata before you press run, so it can't be influenced by non-interface tools before the app runs. The only thing I can think of is to instead use the 'select range' options in the file input interface tool:

FinnCharlton_1-1686066963841.png

 

wonka1234
10 - Fireball

@FinnCharlton  please dont make me do chained app! PLEASE!

FinnCharlton
13 - Pulsar

@wonka1234 aha they're not as intimidating as they sound, and unfortunately they are sometimes the best/only way of getting something working

nagakavyasri
12 - Quasar

Skip the NULL rows using Sample tool and then use 'Dynamic Rename' tool to get the headers.

 

Screenshot 2023-06-06 140739.png

Labels
Top Solution Authors