HiTeam
a
we have one query regarding the configuration files in Alteryx.
We have to copy the multiple cells based on multiple range from input file and paste in output file in specific cells in specific worksheets.
in Alteryx designer we have fixed the range and cells inside the input tool and output tool but if the cells change in future then we have to change inside the Alteryx designer for each and every blocks with is not best approach.
is there any way to setup a configuration file outside the Alteryx and where we put all the cells and range inside that configuration and we can use to replace the cells and sheets accordingly dynamically
Thanks
Ankit Goel
Hi All,
any update on the above query.
Thanks
Ankit Goel
You can make a mapping file tying the dimensions and values of interest to cell values. Then, map the cell values accordingly via the workflow and configure the output path via formula tool to include the specific sheet and cell, then output via that path replacement.
Hi
Can you please share any sample workflow so that we can take as a reference.
Thanks
Ankit Goel