Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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