Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Data formatting

satya04
8 - Asteroid

There needs to be a blank line that separates after each 11 lines. 

 

satya04_0-1678510767110.png

The header needs to be inserted 11 times and should look like this as a separate header for each of the metrics. Please guide me in this regard.

 

satya04_1-1678510891422.png

 

 

12 REPLIES 12
satya04
8 - Asteroid

@ShankerV 

This is the current status. Can you please check once?

 

 

satya04_0-1678522965331.png

 

satya04
8 - Asteroid

@ShankerV 

 

I am able to generate output now. This is how it looks. Is it possible to convert the data in number format with the period (eg CQ12020) remaining the same?

 

I would then be able to prepare charts from the data. Please guide me on this.

satya04_0-1678524951133.png

 

kimlam
6 - Meteoroid

@satya04

you have text (CQxxx) in the columns so data type has to be string. If you want some formatting for the numbers, you can consider using report tools or output data to a template, where you dump data into a tab and set up formulas to bring it into the main report.

Labels
Top Solution Authors