Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Split Data and write Output to an existing template and create multiple copies

DataPirate26
10 - Fireball

Hi All,

 

The requirement I have is to Split a consolidated file into Separate workbooks on the basis of a particular field - "Assignee Name". So for each of the Assignee there will be a workbook which will have that particular Assignee's Data in it. 

 

But We need to write the data into a particular given template which I have shared below. So from Row 1 to 16 all the details will be provided. We have to write the data from row 17. So we have to take into Account 6 FieldsAssignee Name, Work Description, Service Country, Cost Center, Side of Books and the Last one is Total fees in USD.  Line 24 in blank and the Last row will have the Summation of the Total fees as given. Also the output File name will be Assignee First name,Last name Period of invoice ( ex- Aarav Mendis-August to December 2021)

 

Need urgent assistance on this. Tried with many community Tasks given but not able to achieve it. Any assistance will be helpful.

0 REPLIES 0
Labels
Top Solution Authors