Same data in all rows

[ManuelRodrigues]

Hi Folks,

I have this worklflow and the output i get till col c i want to add another column and the data in these rows should all be 36 any thoughts pls?

Thanks,

Manuel

[Kenda]

Hey @ManuelRodrigues 

Check out the Append Fields tool! 

[pedrodrfaria · Accepted solution]

Hi @ManuelRodrigues 

So you are trying to add a new column with a fixed value for data? Is the 36 a dynamic value based on something else or is it just 36 ?

Add a formula tool, create the column and populate it with just "36". Then you will have it all populated.

I dont know if i misunderstood it. Let me know if this is not what you are looking for.

Pedro.

[jamielaird · Accepted solution]

Hey @ManuelRodrigues 

If you literally just want 36 in every row of the column you can do this by adding a Formula tool as shown below:

https://www.screencast.com/t/Ohdyq8BkGQ

[ManuelRodrigues]

Its not dynamic so the formulae tool is what i was expecting to use but what expression do i need to use pls?

[pedrodrfaria]

@ManuelRodrigues 

Literally just write 36 and put in the data type you want it, be it string, so "36" or numeric, so 36

[ManuelRodrigues]

Sorry for the bother - any ideas what i am doing wrong here pls?

datetimeformat(Right([Name], 11), '%Y%m%d'