Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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