Alteryx Designer Desktop Discussions

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

How to clean-up and transform multiple columns into data-base sheet

Klapkalash
5 - Atom

Hi,

 

I'm getting this ugly report from Adobe with multiple columns, totals, etc and need to transform it to a database-like sheet.

Sorry if this is basic, but I'm new to Alteryx.

 

1) need to remove all rows where there is NO DATE in column B (those are useless totals and subtotals)

2) need to convert multiple columns into multiple rows repeating the State / date fields

 

Thanks SO MUCH for your help!

 

See pictures below

 

Need to transform FROM THIS:

From.jpg

 

Into something LIKE THIS:

To.jpg

2 REPLIES 2
ArtApa
Alteryx
Alteryx

Hi @Klapkalash - Here is a possible solution: 

ArtApa_0-1677709855170.png

 

binuacs
20 - Arcturus

@Klapkalash One way of doing this

binuacs_0-1677711907931.png

 

Labels