Hi, I'm new in Alteryx tool and looking for paste the cross tab result into existing excel file in the specific cell range. I have made 3 cross tab results and want to paste in each sheets in existing file. I have tried Output tool option with "existing sheet option", but no luck. Even I tried the "amend and delete" option this was not worked due to dynamic range output from Cross tab tool. So this would be more helpful if anyone will come with a solution.
Solved! Go to Solution.
Hi @troy_mech You have a couple options:
1. Output to a named range,
This can be done to a dynamic named range by creating a "table" in excel, then having a named range be == to that table, so when the table expands so does the named range
2. Outputting to a specific range of cells (e.g : A:C or A1:B1")
The second option can be done so that you overshoot the amount so "A:BB" to make sure all data can fit in the range.