Hello All,
I am new to alterxy and need an help with below requirement
Objective: A company processes ticket requests for an upcoming concert. We can only allocate 200 tickets per day to the requests in the order they were received (request volume is obtained from the [Tickets Requested] field). We have the date the tickets were requested but we need to obtain the order using the logic below and add a column that contains the tickets allocated to each request.
The FIRST FOUR characters of the ID field indicate order. Numerical values are ranked higher than alpha characters. The order goes from 0-9 (rank 1-10) then A-Z (rank 11-36) for each position. So if the first 4 characters of the [ID] field are C3N1, the rank for each is 13-4-24-2. That rank would fall below 10-5-30-5 because the first position is ranked lower (13 v 10). However, it would be higher than 13-8-21-1 because the first position is tied (13 v 13) but the second position is ranked higher (4 v 8).
Summary of Data: ID, Date, and quantity of tickets requested.
I have attached .yxmxd file. Need help
