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.

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