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 · Accepted solution]

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.

[StanislavaV]

thank you  it worked..i was confused with those /output values/ too