Select the same records with a multiple file input and select records in a non sync order

[Mikkel94]

Hi all,

I have a problem with the select records tool. For my data analysis I need to input specific records from a file in a specific order, not in a synchronical order.

Also I want the same records to be imported for all 350 files (see screenshot).

I hope you can help me!

Mikkel

[RolandSchubert]

Hi @Mikkel94 ,

you could use a Batch Macro to read the files. In the Macro, add a RecordId, use a formula to create an OrderId field (e.g. set the OrderId to 1 for RecordId 42, OrderId 2 for RecordId 37). Then filter only records with an OrderId.  See attached workflow for a (very simple) example.

Best regards

Roland

[Mikkel94]

Hi Roland, 

Thank you for your quick response!

Unfortunately I'm not able to open your example due to version differences of our applications...

Can you provide me with a screenshot?

[RolandSchubert · Accepted solution]

Batch Macro:

Workflow:

[danilang · Accepted solution]

Hi @Mikkel94 

Open the .yxmd and the .yxmc files that are created after you import the package in Notepad.exe and change the second line to match your version Alteryx

<AlteryxDocument yxmdVer="2019.3"> 

Change the 2019.3 version number to match yours.

Dan

[Mikkel94]

Hi Roland,

Thank you for the sprintscreen. I've created the workflow like you did but for some reason my second file is not included by the formula in the macro.

So the records and sortID work for file A but I want File B, and C etc to have the same order so that the same rows from A, B, C, etc are the output.

I have attached my macro to this reply. Hope you can help. The specific order works perfectly btw!

[RolandSchubert]

Hi @Mikkel94 ,

do you pass "*.xlsx" as a parameter to the BatchMacro or single file names? Macro will only work, if you pass the filenames one by one. The mismatch between RecordId and recordnumber in your screenshots is a little bit confusing,

Best regards

Roland

[Mikkel94]

Hi @RolandSchubert ,

I solved my problem with a tile function. This way the order starts over at every file.

See macro in attachment.

Thanks a lot for your help!

Best regards,

Mikkel