Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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
Solved! Go to Solution.
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.
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.
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.
(filter + count + append + count) to check whether still have more files. if no, output the result.
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.]
