Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
community Alteryx IO MyAlteryx
alteryx Community
Search
This Board
  • Global Community
  • This Category
  • This Board
  • Knowledge
  • Users
 cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Connect Discussions

Find answers, ask questions, and share expertise about Alteryx Connect.

Create line numbers for invoices

bjmdm83
6 - Meteoroid
‎12-10-2018 02:32 PM

I need to create line numbers to invoice numbers in an excel report. If there is only one item on the invoice the line number would be -0001, but if there is more than 1 item on the invoice I need Alteryx to create subsequent line numbers; ie. -0001, -0002, -0003, etc. 

Labels:
Reply
0 Likes
1 REPLY 1
DavidP
17 - Castor
17 - Castor
‎12-10-2018 02:46 PM

How about something like this?

 

line item number.png

line item number.yxmd
Reply
0 Likes
Copilot AMA
Live Office Hours
Top Solution Authors
View All