Alteryx Designer Desktop Discussions

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

Add text, col and row

poornimak
7 - Meteor

Hi, I am trying to achieve the attached output. I need to add an empty column and a row.

and add text above my table. 

 

Thanks!

6 REPLIES 6
ShankerV
17 - Castor

Hi @poornimak 

 

As per the highlighted one in Red, I believe you need to add a row with some information.

 

ShankerV_0-1673867840171.png

 

This can be achieved by below.

 

ShankerV_2-1673868044687.png

ShankerV_3-1673868059827.png

 

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

 

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

 

Many thanks

Shanker V

 

ChrisTX
15 - Aurora

To add empty columns, use the formula tool with a formula like Null() or ""

 

To add empty rows, use the Generate Rows tool.  Click the tool in Alteryx, then click Open Example.

 

Chris

poornimak
7 - Meteor

I also need to input data in col B where I have give dataline1-dataline8.

ChrisTX
15 - Aurora

To input data use a Text Input tool.  You may need to use a Select tool after that, to adjust data types and/or lengths.

 

Chris

Felipe_Ribeir0
16 - Nebula

Hi @poornimak 

 

If you dont need to generate the layout if the output (collors, borders, etc), here is one way of doing this. 

 

OUTPUT:

Felipe_Ribeir0_1-1673870569831.png

 

 

ShankerV
17 - Castor

Hi @poornimak 

 

Hope you are expecting the result like below.

 

ShankerV_0-1673870467812.png

 

An empty row at the top. 

An empty column at the left, 

This helps to insert the empty column at the left.

ShankerV_1-1673870543217.png

 

Many thanks

Shanker V

 

 

Labels