community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

Enter a new row and auto fill it

Meteor

I want to Enter a new column and auto fill it  so if my data had originally looked like this:

 

ABC       CAD

BCA       CBD

BVC       DKS

CBS       DHW

CKS       UDW

 

I want to create a new column and auto fill it all the way down to where the data ends on the two original columns like so 

ABC       CAD      USD

BCA       CBD      USD

BVC       DKS      USD

CBS       DHW     USD

CKS       UDW     USD

 

The original data will be from an excel upload. 

 

Alteryx Certified Partner
Alteryx Certified Partner

Hi @JamesG2806 

 

Would a single Formula Tool with "USD" inside the expression work?

 

Cheers,

Pulsar
Pulsar

@JamesG2806 

 

Try adding a Formula tool, creating a new column and naming it whatever you'd like and typing in the Expression editor: 

"USD"

 

 

Capture.PNG

Labels