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

General Discussions

Discuss any topics that are not product-specific here.

Formatting in Output

TwylaXBlack
8 - Asteroid

I need to format the output so there is only one cell for the Date field as example below.

 

This is what I have

DateSiteAccessioned VolumeQueueWIPOldest in Queue
2022-09-14Mercury1,915207,37948,940345
2022-09-14Neptune6,4101,298,511974,361939
2022-09-14Mars 1,4641,640,8320
2022-09-14Jupiter502649,5133,498
2022-09-14Earth96,72507560
2022-09-14Saturn4,775020
2022-09-14Venus2,317,601139,735132,1423,376
2022-09-14Total2,427,4761,647,1152,846,5468,158

 

This is what I need it to look like.

 

TwylaXBlack_0-1663196703631.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@TwylaXBlack 
I am not sure there is a stting can be done for that purpose.
and if not , maybe we can do something tricky, like hiding other cells of first of your columns.

TwylaXBlack
8 - Asteroid

I was able to hide some cells and get the date the one time. However, the borders are still there in the date column.

Labels