Unable to get output file renamed and specific excel cells filled up

Question

Hi,

I am trying to get an .xlsx output from 2 sources of data, 1 being numeric and 1 being a string text. If I union the 2 files together It will come out as a string, so instead of doing that I am trying to get specific cells filled up in my output excel file (So as to keep the number format for my numbers.

My other requirement is that I require the file name to be named based in a specific way which I have attached inside the sample file.

Is there anyway to do this? I am unable to get my desired output which should look like:

1              2            3           4

HEADER
this          is            a           test

food        300       300         300

clothes   150        300         400

Along with the file being renamed.

sample workflow 2 outputs.yxmd

MikeBird · Accepted Answer

Hi, 
Your output tools are set to replace the entire file path and that includes the range you are overwriting.  If this is not set then it will start at the top row of the spreadsheet by default.  You will need formulas with the data flow to make sure the output is written to the correct Excel tab and range. 
I've made some tweaks to your workflow and attached it which are: 
Formula in line for the header row to create the top 3 lines of your data, down to the 'This, is, a test' row. 
Formula in line for the main data which writes the rest of the data from the other input. 
I also noticed that your second output had the property 'Skip Field Names' unset.  With this unset you will have a duplication of the field names '1, 2, 3 4'
Both outputs I have removed the 'range' from the output as this is taken care of in formulas within the workflow. 
As a rule, the second formula I mage this range 'A4:D'. If you do not add a number after the 'D' it will simply start at row 4 and continue to write until all data is used up.

The output which outputs the main headings, I have changed the property for 'Output options' to Overwrite File (Remove) which will ensure a complete set of data every time it is run. 
Finally, one last thing I have done is replaced your 'block until done' with conditional containers.  I have found 'Block until done' unreliable in cases like this so been replacing them in my own work. 
I hope all this makes sense.