nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">.</SPAN>strftime<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">(</SPAN>u<SPAN class="" style="color: #669900; border: 0px; font-weight: inherit; font-size: 14px;">"zzz{0}d{0}m{0}Y"</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">.</SPAN>format<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">(</SPAN>chr<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">(</SPAN><SPAN class="" style="color: #990000; border: 0px; font-weight: inherit; font-size: 14px;">37</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">)</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">)</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">)</SPAN>

Where is my mistake please?

Find more posts tagged with

Accepted answers

Hornbydd

I think your problem is coming from you accepting default names. You have output_value, output _value (2) and %output _value%.shp (3).

You have outputs of outputs of outputs all with subtle variation in names! So it is confusing to follow and as you are discovering confusing to program.

Looking at your model the input to table to excel is %output _value%.shp (3) but that is not what I see in your parameter.

I suggest you STOP and take a little time (only 1 minute!) and rename your outputs with more sensible names then when you start inserting them as inline substitution it is much clearer for you to set up.

Hornbydd

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:

\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:

\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.

All comments

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.

StanislavaV

thank you....:) works now

Hornbydd

\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:

\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

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

Hornbydd

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.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.