Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

import multiple table data set into multiple sheet in existing excel file

troy_mech
8 - Asteroid

I have created three tables in alteryx and need to paste those table values in standard excel template. Each tables need to be pasted in specific sheet and specific cell (example A14) but this should not depended with cell range. Could anyone please help me on this

1 REPLY 1
morr-co
10 - Fireball

Would it be possible to calculate the range end in your workflow? For example, if you use a Count Records tool you could add that value to 14 to get the ending row. You could then determine the column based on the number of columns in the output. Using that value, you could dynamically update the range-end value using a macro similar to the mock up below.

 

Screen Shot 2020-10-28 at 4.23.30 PM.png

Labels