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

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Data format to Single line

Jaganmohan
8 - Asteroid

Hi Team,

 

I am trying to fit the information in a single line (row)  based on Medicine Name Code and Product Code - Could you please assist me on how to fix this issue.

Please find attached excel sheet having two tabs,

1) Tab1 : Original  input 

2) Tab2 : Required output.

 

Thanks in advance.

3 REPLIES 3
ArtApa
Alteryx
Alteryx

Hi @Jaganmohan - Here is a possible solution:

ArtApa_0-1655858097221.png

 

ArtApa
Alteryx
Alteryx

Hi @Jaganmohan - Are you happy with the solution? 

Jaganmohan
8 - Asteroid

Thanks a lot - I am good with the provided solution.

Labels
Top Solution Authors