Dynamic File and Sheet Name with Render/Layout Tools

[cmohyi]

Hey there,

I know there are a few threads on this topic but I haven't found any that solve my issue. I have a workflow where I'm using the Render tool to output formatted Excel sheets with a dynamic filename into 4 different tabs. Everything works great except that the output gives me standard "sheet1", "sheet2", etc names without an option to rename them. I know that the Layout tool can accomplish this but then I can't use the dynamic filename. I need to keep the dynamic filename and can't compromise on any of the formatting. Any suggestions for how to accomplish this?

Thanks a ton in advance!!

Cameron

[AbhilashR]

Hi @cmohyi, can you take a look at the attached sample workflow and let us know if this is what you are looking for? the workflow has multiple formula tools which define the individual excel tab names after each Table tool. They are subsequently Union'd and passed onto the render tool for output.  

[DaveSchloat]

Hey, thanks - this was helpful - the dynamic sheet name is working.

However, I would really like to able to have a dynamic file name as well.  I have the path/file name I want to use in a field, but the render tool doesn't allow me to "program" both.  I tried using file path/filename.xlsz|||sheet name as one big field, But I got the following error:

Error: Render (432): The file "filepath\file name|||sheet name" is not a supported format. 

Any ideas?  Thanks!

[Peter_Guirguis]

Hi Dave, 

here is an updated version of Abhilash flow with filename and filepath included as well as the tabname.

let me know if that helps. 

[OTrieger]

@Peter_Guirguis , @AbhilashR 

This is a perfect example why you should not share WFs with people. I know that you are trying to help, however it does not give the help that the person was looking for. Why?

Simply as he is lacking some knowledge in this area and despite of the fact that you shared with him a solution or partial solution he does not know what to do with it due to the lack of knowledge.

I keep getting responds why it will be fine to share WFs, focusing on the exception cases. If you want to help, really help, aid the person get the knowledge so he can work out the solution.

@DaveSchloat  shared an error that he got, I did not see any answer how to overcome it, which is super simple answer, that render does not use the same format of path as the Data output tool. The path for the render you will only need to define until the file type, xlsx etc. The sheet name will come from the setting of the Layout tool.

Knowledge is the ability to implement what you studied, if you cannot implement, well the fact is that there is something that you still do not understand. There are no exceptions for this rule. If you finding yourself that you cannot apply what you just learn, then there is something that you are not fully understand. Go back and find what you do not understand, normally, words, define them and study it again.