Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Adding IDs for records

Pardeep
7 - Meteor
‎01-19-2023 10:58 AM

I have a data output from an Alteryx workflow in the following format:

 

Truck numberFarmDriverLoad TimeProcess Date
133708022 Ont - Petropoulos & Petropoulos HoldingsRaj Singh2023-01-08 22:022023-01-09
139708022 Ont - Petropoulos & Petropoulos HoldingsFrederick Tiffin2023-01-08 22:012023-01-09
152708022 Ont - Petropoulos & Petropoulos HoldingsJorge Fonseca2023-01-08 19:062023-01-09
133753522 Ont - Fred DeboerRaj Singh2023-01-09 0:292023-01-09
170753522 Ont - Fred DeboerYuriy Khatnyuk2023-01-09 0:382023-01-09
193753522 Ont - Fred DeboerMiguel Mbala2023-01-09 3:142023-01-09
105Clark Bonnie BraeCalvin Brown2023-01-09 8:512023-01-09
124Clark Bonnie BraeBenjamin Christian2023-01-09 7:302023-01-09
141Clark Bonnie BraeDemoy Forrest2023-01-09 8:302023-01-09
143Clark Bonnie BraeDon Belmar2023-01-09 9:262023-01-09

 

There are days a driver will do two loads in a night. I want to add an IDs column to the loads based on the load time and want the output in the following format

 

Truck numberFarmDriverLoad TimeProcess DateID
133708022 Ont - Petropoulos & Petropoulos HoldingsRaj Singh2023-01-08 22:022023-01-091
139708022 Ont - Petropoulos & Petropoulos HoldingsFrederick Tiffin2023-01-08 22:012023-01-091
152708022 Ont - Petropoulos & Petropoulos HoldingsJorge Fonseca2023-01-08 19:062023-01-091
133753522 Ont - Fred DeboerRaj Singh2023-01-09 0:292023-01-092
170753522 Ont - Fred DeboerYuriy Khatnyuk2023-01-09 0:382023-01-091
193753522 Ont - Fred DeboerMiguel Mbala2023-01-09 3:142023-01-091
105Clark Bonnie BraeCalvin Brown2023-01-09 8:512023-01-091
124Clark Bonnie BraeBenjamin Christian2023-01-09 7:302023-01-091
141Clark Bonnie BraeDemoy Forrest2023-01-09 8:302023-01-091
143Clark Bonnie BraeDon Belmar2023-01-09 9:262023-01-091

 

 

Raj did two loads that night, so his first load at 10 AM is marked with ID 1 and his second load at 7 PM is marked with ID 2.

 

I am not sure if there is a tool in Alteryx that can help me with this. Thank you for any help.

Labels:
Reply

Accepted SolutionSolved! Go to Solution.

5 REPLIES 5
BS_THE_ANALYST
15 - Aurora
15 - Aurora
‎01-20-2023 10:20 AM

@Pardeep  Please see attached! You can use the Tile tool :). I've made some extra mock data so you can see how the tool scales with more data .. 

BS_THE_ANALYST_0-1674238800445.png

 

All the best,
BS
LinkedIN

Bulien
200123TILETOOLyxmd.yxmd
Reply
binuacs
21 - Polaris
‎01-20-2023 10:32 AM

@Pardeep One way of doing this with the multi-row tool

 

binuacs_0-1674240969640.png

 

 

Assign_ID_012023.yxmd
Reply
Pardeep
7 - Meteor
‎01-24-2023 05:32 AM

@BS_THE_ANALYST  @binuacs  Thank you guys both solutions worked perfectly for me. Really appreciate all the help.

Reply
BS_THE_ANALYST
15 - Aurora
15 - Aurora
‎01-24-2023 08:19 AM

@Pardeep great news! 😀. If you mark posts, which helped, as solutions, it can help future people who experience the same problem and come looking for a fix! 

All the best,
BS
LinkedIN

Bulien
Reply
0 Likes
Pardeep
7 - Meteor
‎01-25-2023 05:10 AM

@BS_THE_ANALYST  I will do that.. very new to this community so still learning. 😇. But you guys are the best.. 

Reply
GenAI Contest Form
License admin COmmunity Live
Labels
Top Solution Authors
View All