Prioritizing Run Command to Copy a Template

Here is one way of doing it:

In the Output tool when you select the excel file, tick and specify a range that matches the columns you're outputting data to:

Then set the tool up as follows, noting the Output Option and the Preserve Formatting tick:

All comments

One option is to use the Block Until Done tool (under Developer tab in the ribbon), configured like the screenshot below:

The Run Command tool will run first, and only after this has completed will the next stream run.

HI @davidskaife

Thanks for the response. I already thought of the "block and done" however my question is how I can connect it with other workflow since it has its own input file. Please see attachment below.

Can you please let me know where to insert the block and done tool?

2 Workflows.PNG

Looking forward.

Kamen

Ah ok, so they are separate streams? You have two choices then:

Download the CReW macro pack here http://www.chaosreignswithin.com/p/macros.html and use the Parallel Block until Done tool, or, if you're unable to do that try option B

Option B - workaround:

create a dummy field (in my example i've called it Dummy Field)
place the Block Until Done tool before the Select and Run Command Tool
in that Select tool remove the Dummy Field
Append the Dummy Field only to the other workstream
use another Select Tool to remove the Dummy Field from the downstream
carry on with the workflow as normal

This should cause your workflow to execute the Run Command first, and then once completed run the rest of the workflow. I've attached my dummy workflow so you can see the principle of it

Block Until Done.yxmd

I've tested your workflow however I still have problems with the results. My 2nd workflow still overwrites the first row with format. What should I do in order for the 2nd workflow to ignore the header so it won't overwrite the formatted temaplate?

Sample Template - it is formatted with color on the header.

Template Format.JPG

My 2nd workflow (sample)

Other Workflow.JPG

This is the results I am hoping for:

Should ResultJPG.JPG

Looking forward

Kamen

Here is one way of doing it:

In the Output tool when you select the excel file, tick and specify a range that matches the columns you're outputting data to:

Then set the tool up as follows, noting the Output Option and the Preserve Formatting tick:

I changed the output file configuration and it is not working. I forgot to say that I have a formula tool that allows the output tool to change the file path. My formula tool has this:

FileGetDir("FullPath\Output") + "Report.xlsx" + "|||" + "Sheet1"

Is there a way to indicate the row and columns? I'd like to start with A2 to exclude the header because I have a header formatted?

Please advised

Kamen

All you should need to do is update the formula to FileGetDir("FullPath\Output") + "Report.xlsx" + "|||" + "Sheet1$A:D"

Don't worry about starting on A2, as long as you tick the Preserve Formatting on Overwrite in the Output tool it will keep the formatting on the header

Your response below works for my first template to output file. However in my 2nd template, no data were copied. It was able to copy the template to the output folder but no data. I did the same like on the first template. Am I correct to below screenshot for having the 2nd template? What do u think did I missed? Why I was not able to capture the data on the 2nd template?

Two Template.PNG

Please advised,

Kamen

Is it the same data you're writing to the second template? Are you able to share the workflow as it's tricky to troubleshoot from screenshots

The issue has been solved. I was not able to put the suffix ".xlsx" in my formula tool. Now I am able to paste the data into the templates (3 templates) successfully.

Now, I have another problem. Is there a possibility for me to add the month date and datetimetoday? because I would like to format of the filename will be "Month Date" "Filename" "Datetimetoday". Whenever I add this in my formula tool, it gives me another file which does not contain the format.

I suspected maybe because of the output filename placed under text tool as seen below where the run command use to create a copy?

Two Template.PNG

Please advise if there's a way to add date in the filename.

Thanks,

Kamen

Yup there is, you simply need to add into the formula something like the below, which adds the date today to it:

"\\Filepath "+DateTimeToday()+" Filename"

note however if you are using any TIME outputs you must use the same for all your formula, as time is specific down to the seconds so the files will never match.

An easy way to do DateTIME is to start with the DateTime tool, and append that stream to all that require it, so there is consistency

I have tried this ""\\Filepath "+DateTimeToday()+" Filename" in the formula tool which is placed before the output tool but what happens is that it created a separate file and even though I have checked the "preserve formatting on overwrite (range required) in the output tool, the created file removes the format I designate in the template.

Is there any other way to rename my file without removing the format like below.

Template Format.JPG

Need to rename my file from (for example) Singapore Report to 12-2022 (refers to month date) Singapore Report 12-21-2022 (refers to date today)

Please advised.

Kamen