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

General Discussions

Discuss any topics that are not product-specific here.

Move date field up one level and then delete the two empty rows.

55dhr
6 - Meteoroid

here's the problemhere's the problem

3 REPLIES 3
55dhr
6 - Meteoroid

Really need help with this one!

Qiu
21 - Polaris
21 - Polaris

@55dhr 
Can you provide a sample input and desired output to help us better understand your question?

Input is better in data format rather than snapshot. 😁

Yoshiro_Fujimori
15 - Aurora

Hi @55dhr ,

As @Qiu mentioned, you would get responses more quickly if you add a sample imput and its expectd output.

But I created a workflow assuming what you may want.

I hope it helps.

 

Workflow

1262761_Workflow.png

 

Input

DateProduct NameFunctionPrice
 2024-04-15  
    
 ComcastPhont/Fax/Internet303.31
 2024-04-13  
    
 abcSoftware/Hardware492.45
 2024-04-12  
    
 MicrosoftSoftware/Hardware14341.69

 

Output

DATEProduct_NameFunctionPrice
2024-04-15ComcastPhont/Fax/Internet303.31
2024-04-13abcSoftware/Hardware492.45
2024-04-12MicrosoftSoftware/Hardware14341.69
Labels
Top Solution Authors