Hello all
I want to get an Excell output file and change the name according to the field ie FW validation 123456.xlsx, FW Validation 958475.xlsx. I have selected "Change Entire File Path" however it keeps throwing an error.
I was using same method in the past which worked fine but donot know what is going on now.
Could you help me to sort this out please?
Thank you
Selcuk
Solved! Go to Solution.
Hi @slckkrky, in your [Wrapper_ID] column definition, are you also including a sheet name? I just tested, and when I create a column [Wrapper_ID] as follows:
[Wrapper_ID]
"c:\temp\excel_file.xls"
It fails with same error...when I add in the Sheet name, it works:
[Wrapper_ID]
"c:\temp\excel_file.xls|||Sheet1"
Question - I see on your Output File tool, you are outputting to XLS format, but in your post, you are referencing .xlsx version - the naming convention above should work for both, but just wanted to note that you have both listed, so not sure if that is by design.
Hi BrianR
ignore the xlsx. please. It is designed xls.
Could you tell me where do you add the sheet name?
Thank you
Selcuk
You can add that in a Formula tool - such as this:
Then in your Output tool, if you configure it like your screenshot shows - i.e., check the box "Take File/Table Name From Field" and then choose "Change Entire File Path" - and choose [Wrapper_ID], it should write out correctly.
I pasted the path of my output file in formula tool. Now it worked without an error, however it doesnot add anything at the end of file name. Could you share your workflow please?
Another question, what happens if you have multiple value in Wrapper Id column. How the file will be named then?
Thank you
Selcuk
Hi,
check the solution for this problem and it will help you:
I attached my version of the workflow - and I built in some variability which I think should help with your question. For example, I modified my formula to create a more dynamic file name, taking columns from my input data, and stitching together a complete filename that will change with each row in my data.
Take a look at the attached - and here's the new formula I created:
Regards,
Brian
If this solves your issue, please consider marking this as Complete so others can find this as well.