In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start 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
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