Jump to content

Generating attribute pairs

Recommended Posts

Hi Andrew!

Yes, you can make it through a join task with a certain configuration.
Imagine that your key variable is the ID on the screen:


1. You can create a copy of the same dataset by connecting it to another datamanager. Then, you can input both datamanagers into a join task:image.png

2. Now, you need to configure the join as "Inner join", select the IDs as Matching attributes and "<" as Operator:


3. And you are done!



If you want to refine your result, you can also apply a Reshape to Long task on top of this (after dataman3) after creating another variable that identifies the “Pair ID” (you can create it just with an enum()), just to remove the dependence on the attributes ID and ID_1. This will be the final result:



Please be aware that this method will not work with a large dataset, as the join computation could lead to memory issues.

Edited by Alessandro Piazza
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...