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

Alteryx Designer Desktop Discussions

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

Need to copy my output by leaving 1st 6 rows

Naga
8 - Asteroid

Hi All,

 

Good day. I have scenario where I want to paste my output to nth row ,because I am using a template that has used the 1st few rows for standard information. So I need the output records from header need to get pasted from 6th row. I have 200 odd files that has variety of information from row 1 to row 8 and I want a workflow that will not disturb the header and get the output  pasted below 8th row. Though I referred some of the community workarounds, but it not fitted my need.

 

example:

Output, which gets pasted to 1st row of the excel file now

Client Name

ABC

EFG

HIJ

 

However, my template has

Date:

Client

# of Records

 

Expected output

Date:

Client

# of Records

Client Name

ABC

EFG

HIJ

 

 

 

 

 

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@Naga 
I think you are looking for the "Preserve Formatting on Overwrite (Range Required)" option in the output tool?

0322-Naga.PNG

Naga
8 - Asteroid

Thanks @Qiu ...this was really helpful to achieve my need

Qiu
21 - Polaris
21 - Polaris

@Naga 
Glad to be helpful and thank you for accepting my answer. 😁

Labels