Free Trial

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
Top Solution Authors