"No Table chosen..." Error for Dynamic Excell Output Naming

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

Dynamic Processing

Accepted answers

BrianR

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.

ExcelNaming.yxmd

All comments

BrianR

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.

slckkrky

Hi BrianR

ignore the xlsx. please. It is designed xls.

Could you tell me where do you add the sheet name?

Thank you

Selcuk

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703