Output Data - Error: Encountered existing data beyond the specified range

[saachitalwar]

Hello,

I have an excel template that contains a header, a table and some static data below the table.

I have created the table data in alteryx and wish to get the output without fields in -

%User.FolderPath%Input/file.xlsx|||Summary$A4:E4

there is data above and below this range, how can I correct this error "Encountered existing data beyond the specified range"

[Raj]

@saachitalwar 
in the configuration of output tool you have not turned off the table headers
so it is considering it 2 rows thats the reason of error

mark done if solved.

[Raj]

@saachitalwar 
find the snip attached for reference.
hope this helps

[saachitalwar]

I did this but it's giving the same error

Could it be because there's static data outside in the A to E columns but below the table?

[saachitalwar]

%User.FolderPath%Input/ouput.xlsx|||Summary$A4:E19

I tried to specify the exact range but this didn't work either

[Raj]

@saachitalwar 

add a sample input i will hep with workflow

[Raj]

@saachitalwar 
please find the workflow attached
this is working fine

mark done if solved.

[vj28]

@Raj this fixed it, after a full night of being stuck. Thanks a ton!