Alteryx Connect Discussions

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

Create line numbers for invoices

bjmdm83
6 - Meteoroid

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. 

1 REPLY 1
DavidP
17 - Castor
17 - Castor

How about something like this?

 

line item number.png

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!