Combining Fields

[nwatzlaf]

I have values from four different columns that I want to combine.

Origin City     Origin State      Destination City      Destination State

I want the final field to read..

OriginCity,OriginState_to_DestinationCity,DestinationState

Any help is appreciated.

Thank you!

[DataNath · Accepted solution]

Would a simple formula tool not do the trick? I.e. the following:

[OriginCity]+','+[OriginState]+'_to_'+[DestinationCity]+','+[DestinationState]

[messi007]

@nwatzlaf,

You can do this using a formula tool :

Attached the workflow,

Regards

[nwatzlaf]

Thanks so much!