Alteryx Designer Desktop Discussions

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

How to get only column header while processing the data.

dizy_11
7 - Meteor

Hi all,

 

In alteryx is there any way  to select only column header while processing the data? 

Note:- I have to input whole data but just for some data preparation i need to take only headers at some point in the workflow.

 

Is there any tool for doing so?

 

Thanks in advance!

3 REPLIES 3
AkimasaKajitani
17 - Castor
17 - Castor

Hi @dizy_11 

 

You can use Sample tool or Select Record tool.

 

AkimasaKajitani_0-1625280614920.png

 

Qiu
21 - Polaris
21 - Polaris

@AkimasaKajitani 
Nice one. 
I did not N can be set to zero. 😂

atcodedog05
22 - Nova
22 - Nova

Interesting approach @AkimasaKajitani even I haven't used this method before.

 

Hi @dizy_11 

 

Additional to @AkimasaKajitani's method you can also use a filter tool. Filter nulls on a non-null column. Which will filter out all rows to false and you will get only headers in true.

 

Workflow:

atcodedog05_0-1625295494970.png

 

Hope this helps 🙂

 

Labels