Align rows of data

Hi,

I have an issue where I have a number of inputs coming into a "Join Multiple" based on Record Position. The problem being some of the inputs, the record will have 4 or 3, and other inputs will be 2 and 3. When joining this way, there is a mismatch in the rows of data as shown below. eg Park 2 is on same row as Park 1 under "Track".

I want to have the highlighted cells moved down to align with the correct "track" name.

The data set is quite large so not able to join by "specific Fields" (I don't think) using the Join Multiple.

Have included a data sample which shows current and desired output.

Thanks for the help

align.xlsx

Join

Accepted answers

gawa

hi @JimFreeman

I suggest to review your Multiple Join way. Before connecting Multiple Join, it is better to put tile number for each "Track" by Tile tool.

Then, Multiple Join by "Track" and "Tile number". Output by doing this would look like your desired one. Please refer to attached WF.

1210370_gawa.yxzp

All comments

CoG

One way is to use an iterative macro, where all the data is in the macro and joined after being filtered by [Track]. Not really ideal, but it gets the job done.

Macro Workflow.png

MultiJoinWorkflow.yxzp

gawa

hi @JimFreeman

I suggest to review your Multiple Join way. Before connecting Multiple Join, it is better to put tile number for each "Track" by Tile tool.

Then, Multiple Join by "Track" and "Tile number". Output by doing this would look like your desired one. Please refer to attached WF.

1210370_gawa.yxzp

flying008

Hi, @JimFreeman

How many types in your filed [Track] ? Now 2 in your sample data, but about most ?

JimFreeman

Hi, there would be between 10 to 15 different types.

AncientPandaman

when I saw 8~files, I happier to use directory + macro

logic similar to @gawa. join by [Track] and [Tile_SequenceNum]

Load first file and add tile,

use directory to get files, remove the first file (workflow)

Load each file, and add tiles, join with first file and repeat (macro)

note: plan to use join to do the filter but the filename get from input tool is missing extension 😒, no choice to use 3 tools to do same things.

Screenshot 2023-11-17 174730.png

(filter + count + append + count) to check whether still have more files. if no, output the result.

Screenshot 2023-11-17 174741.png

file_row_align.yxzp

flying008

Hi, @JimFreeman

Maybe there is always a better way for this case: [If you can upload more data for test, this method will be robust.]

录制_2023_11_18_11_49_10_919.gif

JimFreeman

Thanks Gawa, this has fixed my issue, was just needing a tile in there!

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335