Alteryx Designer Desktop Discussions

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

Only one header

DanielCarro
8 - Asteroid

Hi guys,

 

I need to have just one header, so all on row 1. I tried using multi-row formula but not working

 

ayx111.JPG

 

I tried using multirow formula but giving me error

 

ayx112.JPG

 Much appreciated your assistance on this  one.

 

Kind Regards,

Dan

 

 

 

 

5 REPLIES 5
TimN
13 - Pulsar

If you know how many rows make up the header then maybe something like this...

binuacs
20 - Arcturus

@DanielCarro summarise tool is an option in your case

 

image.png

Raj
15 - Aurora

If all the other values are null you could have just used Summarize tool with longest action.

AndrewDMerrill
13 - Pulsar

If you have data and headers in the same table, here is a workflow that can get the job done regardless of where the column headers are, assuming the header is the top value in every column and no data occupies any of the rows where the headers are. Example:

Field 1Field 2
Null

Header 2

Header 1

Null

Data 1Data 2

This is a good example since no data values occupy rows where Headers are. Example 2:

Field 1Field 2
Null

Header 2

Null

Data 2

Header 1Null
Data 1Null

Bad example because Data 2 is in a row above Header 1. The workflow will not work properly in cases like this.

 

_Main.png

 

To make this process more dynamic and allow for cases like Example 2, a macro is required. But your example makes me think that is not necessary.

DanielCarro
8 - Asteroid

Hi @TimN ,

 

Your solution worked great.

 

Many thanks,

Dan

Labels