Output data to the dynamically inputted file

[CindyZ]

Hi,

I have been working with data from an excel inputted using the dynamic input tool. I would like to update those same data and output them onto the same input file (which name was dynamic). Would anyone know how that could be done?

Thanks!

[gawa]

@CindyZ 

You can utilize the below option in Output tool to dynamically change the path of output files for each record.

To specify sheet name, insert triple bars ||| after file name like;

....\output_excel.xlsx|||Sheet1

You can create dynamic path name by Formula tool or something, and specify that field in the below config.

[CindyZ]

@gawa

Thanks for your reply. Since I already have a file linked to the output tool, how would I be able to link the dynamic path name from the formula tool into the area you specified?

Thanks!

[gawa]

@CindyZ 

As I cannot specifically advise, kindly share your work flow in yxzp. (Option=>Export Workflow) here.

[CindyZ]

@gawa

In the zip folder you would be able to see the workflow, the "Sample Doc 11-29-2023" which is the dynamic input file (due to the date that changes everyday), and "11-2023" which is the output file generated from the workflow (which content I'd like to update back into the "Sample Doc 11-29-2023" file, "Report" tab, columns A to H and N to O starting from row 2).

In short, the goal is to have the content of the "11-2023" file be updated back into the "Sample Doc 11-29-2023" file, instead of generating a new "11-2023" file.

Please note that the input file is a random file that I created but includes features that I would need to keep in the input file (e.g. macros and preset formulas).

Thanks a lot!