How to put files in standard template

Question

Hi,

I've a standard template with some color coded column names and i've some input files .

I want to simply copy data from input files to the standard template removing headers of input file and keeping everything in template file. And the color code of template should also be not disturbed.

Is it possible to achieve in alteryx?

Template:

Some headers    systemsystemsystemsystemsystemsystema1     DateNumTypeAcctCodeName

Input:

DateNumTypeAcctCodeName10/7/2021182S2002000ABC10/7/2021182S2092300DEF10/7/2021182S2122000GHI10/7/2021182S3132000JKL

Output:

Some headers    systemsystemsystemsystemsystemsystema1     DateNumTypeAcctCodeName10/7/2021182S2002000ABC10/7/2021182S2092300DEF10/7/2021182S2122000GHI10/7/2021182S3132000JKL

template.xlsx

Input.xlsx

AZuc · Answer

@Pandey19

Sorry, this is the correct link https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Excel-output-to-formatted-sheet/td-p/558978

You basically need to configure your excel output in a way similar to this one

Pandey19 · Answer

@AZuc ,

I just want to copy my input data and paste into template file . Row 1 to 4 will be the headers from template file and from row 5 will be my input data

AZuc · Answer

@Pandey19

I believe the answer is in this link https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Outputting-to-a-formatted-excel-template/td-p/544415