Alteryx Designer Discussions

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

Converting row to column

Harsh14
8 - Asteroid

Hi,

In my workflow I want to convert the below highlited Account number field into a column aligned with Rule name, Rule description column.

IMG_20211013_181231__01.jpg

 so that my output should look like

IMG_20211013_181808__01.jpg

 Any help on this?

6 REPLIES 6
dougperez
11 - Bolide

Can you provide a dataset? 

I think you will have to isolate these two and then append then, but with a dataset I can do it for you!

Harsh14
8 - Asteroid

can you help me with an example through text input  or an example dataset? 

because i wont be able to download the dataset

Christina_H
11 - Bolide

Here's a simple version with some made up data.

Christina_Hurrell_0-1634129920169.png

 

Harsh14
8 - Asteroid

Hi, Thanks 

but what if this process is repeating mulitple times in the same excel.

I mean I have taken a wild card input for 20 csv files in single excel and evry file contains different account number 

so i want these account numbers to be aligned for all 20 files.

DawnDuong
12 - Quasar
12 - Quasar

hi @Harsh14 

Can you clarify "a wild card input for 20 csv files in single excel"? 

Do you mean that

a) you have 20 different files that have the same format and you want to process them the same way?

Or b) you mean something else?

If your use case is (a) then you can get it done via a batch macro to process all files that exist in a specified folder. Check out this very useful thread on how to read multiple files: https://community.alteryx.com/t5/Engine-Works/The-Ultimate-Alteryx-Holiday-gift-of-2015-Read-ALL-Exc...

 

Dawn.

Christina_H
11 - Bolide

@Harsh14 Here's an updated version that will work for multiple files.  I've created both file IDs and row IDs, you might already have a different way to identify the files.

Labels