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

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
Top Solution Authors