Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!
SOLVED

Report text spacing

Highlighted
7 - Meteor
CompanyEquipTime
ABCAC12:00
  01:00
BACFAN13:00
  14:30
 Light15:00
  17:00
CABFAN23:00
 Light01:30
 AC02:30

 This my data set where I want the data in word document when using the report text tool there is row gap could you please help me I dont want any row gaps.

 

The output should be in below format.

ABC

  AC

    .12:00

    .01:00

BAC

 FAN

  . 13:00

  . 14:30

Light

 .15:00

 .17:00

CAB

  FAN

   .23:00

  Light

    .01:30

AC

.02:30

 

Highlighted
9 - Comet

Hi @abhijeet_86 

 

You can transpose your data and remove the row gaps. You won't be able to indent any fields using this method, so I added a formula tool at the beginning of the workflow to add the indents to get the desired formatting in the Report Text tool. 

 

Maskell_Rascal_0-1588709811031.png

 

Try out this workflow and let me know if it works for you.

 

Thanks!

Phil

Highlighted
7 - Meteor

HI @Maskell_Rascal  thanks for the solution need one more help i need to have bullet points in Time , however when I am adding it is really small wanted to have bold could  not able to figure it out

Highlighted
7 - Meteor

Hi @Maskell_Rascal the bullet point issue solved

Labels