community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Data conversion from payslip format

Asteroid

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

Asteroid

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

Labels