Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Data conversion from payslip format


Hi Experts,

Need a help to convert data from payslip format to row wise format. This is part of another work flow where I need to convert from a folder with multiple excel files which was originally pdf files but converted to excel files.


Need a help here, "Actual" highlighted is the format I get and "through alteryx" is the format expected or the data should be finally. Experts please help.


R Raj

Alteryx Certified Partner

Hi @Raj_2 


Here's a workflow that achieves the desired end result. First name wasn't included in your source data so is omitted.


Screenshot 2019-07-11 at 11.07.29.pngScreenshot 2019-07-11 at 11.07.38.png


Thank you for the quick response, the work flow is great