Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How to get data a proper data table from software generate report

chelseariver90
8 - Asteroid

Hi,

 

I've attached an excel spreadsheet that has 2 tabs. 1 with some dummy information in the format it gets outputted and the other with how we need to be able to see the data. 

I've tried using a record id for the information in each line and then doing a multi join on the id but because some of the sections have different numbers of rows under description they end up in the wrong record id for the employee.

How could i do this another way that will link the information to the name and pay period so that regardless of how many items there are under description it will still pull the correct information for the columns needed in the other format?

 

Thanks a lot

 

2 REPLIES 2
DavidP
17 - Castor
17 - Castor

My approach below is a pretty manual one - it uses filter tools to only pick the ones you want from the description section. Initially, I made the assumption that 2 empty lines is the separator between 2 record sets.

 

I haven't mapped all the fields, but you get the idea.

 

DavidP_0-1584560494361.png

 

 

chelseariver90
8 - Asteroid

Thanks David thats worked cheers!

Labels