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
binu_acs
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  @binu_acs  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
Community Live Fifa Workshop
Labels
Top Solution Authors
View All