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

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

Workflow.png

Datasets

Input

Accepted answers

RolandSchubert

Batch Macro:

Workflow:

danilang

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

All comments

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

Sample.yxzp

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?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703