ModelBuilder CalculateValue into OutputName

[StanislavaV]

hello guys,

i wanna ask you - i have tool Table to Excel in ModelBuilder but in the end i want to get XLS with output name included Date.

so i used Calculate value and as you can see it is showing correct date...but when i run my model, XLS has output name "vyber_EU".

In Calculate Value i used this expression from mr. Patterson.

time.strftime(u"zzz{0}d{0}m{0}Y".format(chr(37)))

Where is my mistake please?

[DuncanHornby]

You need to show us what the Table to Excel tool is doing, you would typically use the output of the Calculate Value tool in an inline substitution in the output name of your xls file.

[StanislavaV]

i have shapefile like input and then i want to export XLS file from it but with date  

[DuncanHornby · Accepted solution]

That is your problem you are not using the output of the calculate value tool. You have made it a precondition to the table to Excel tool, we know that as it has a dotty line. Your output Excel file should be:

D:\MPRV SR\GSAA\GSAA2019\eustream\vyber_EU%output_value%.xls

If you had renamed the output of your calculate value tool to something like BOB then your output would be:

D:\MPRV SR\GSAA\GSAA2019\eustream\vyber_EU%BOB%.xls

You need to read the help file on modelbuilder in-line substitution, this is particularly important if you are using iterators.

[StanislavaV]

thank you....:) works now

[StanislavaV]

i have one more question

in that model i have 2x calculate value for output name.

in the first one it says "places_DDMMYYYY" which is in results OK.

but in the second one it is set to "intersect_DDMMYYY" but in the result it is called "places_DDMMYYYY" like previous output.

what can i do to run it OK?

Thank you.

[DuncanHornby]

This is what I was trying to teach you with the BOB example. So what is the name of the output for your second calculate value tool? Is it output_value or output _value (2)? You do not have to accept default output variable names, rename it to something sensible and use that in the in-line substitution.

[StanislavaV]

output for second calculate value tool is this:

 

and then for copy features:

and for table to excel:

[DuncanHornby]

Look at your inline substitution, are you using %output_value% or %output _value (2)%? 

[StanislavaV]

%output_value% .... but when i tried rename it to %output_value (2)% it says that "The name contains invalid characters
Failed to execute"