Dynamic Input Data into Excel Template based off Column Header

Question

Hello everyone,

I am currently using the Blob Input tool to bring in my data that I filtered from a previous excel sheet. There are currently two problems:

1. The data that I am inputting goes into a dynamic column based off the date header from the imported data. When I currently use the Blob tools, it just overwrites the second column of the selected range.

2. The output file must change every month as it is a monthly report. (e.g. this is the Example Jul 24 file)

Key note: input file is currently sourced using dynamic rename and dynamic select tools in the workflow earlier, if that helps.

I can attach my workflow that I've been working on but it doesn't work right now.

Thank you!

240712 Canada Input File.xlsx

Example Jul 24.xlsx

apathetichell · Answer

update the column name by changing row 1. If you are trying to add new formatted columns (ie one day two columns/one day three columns/etc) - that does not work. your template is your template. If you want to overwrite a copy of a formatted template - all of your formatting must be included in the template.

rkimrich · Answer

The problem is that the column dynamically changes daily since this is a daily workflow and the output file will need to be updated daily, if that makes sense.

apathetichell · Answer

template workflow goes like this:

template file - blob input. formula to create new name for file - blob output.

attach your new filename - but not your blob to your datastream. use a formula tool to create specific ranges with the

filename|`sheet|range` syntax. the range should include start and ends - Ie if you want the second column write to b2:b50000 - or whatever. If you don't want the second column - write to a different column.