Oh no! The Community appears to be haunted! Help us find all the spooky specters here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

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

Mikkel94
7 - Meteor

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

7 REPLIES 7
RolandSchubert
15 - Aurora
15 - Aurora

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
7 - Meteor

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
15 - Aurora
15 - Aurora

Batch Macro:

 

26-09-_2019_10-10-14.png

Workflow:

26-09-_2019_10-12-40.png

 

danilang
18 - Pollux
18 - Pollux

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
7 - Meteor

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
15 - Aurora
15 - Aurora

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
7 - Meteor

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

Labels