We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Converting data to different format

ppatane
8 - Asteroid
‎11-19-2024 02:39 PM

How can I change data in first image to second image. In Power Query it is a simple Fill down.

Data1.jpgData2.jpg

Labels:
Reply
0 Likes
4 REPLIES 4
alexnajm
18 - Pollux
18 - Pollux
‎11-19-2024 02:41 PM

In Alteryx it’s a Multi Row Formula!

Reply
binuacs
21 - Polaris
‎11-19-2024 02:52 PM

@ppatane two different approaches

image.png

Fill_Down_19112024.yxmd
Reply
0 Likes
ppatane
8 - Asteroid
‎11-19-2024 03:17 PM

@binuacs @alexnajm I'm sorry, I should have been more specific.  The incoming data on the left is in one row.  I am attaching the csv file

1 KB
Reply
0 Likes
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All