Group by ID to run the R tool

Hello,

I have a workflow to calculate X and Y coordinates using igraph library in R tool. My input file contains project group ID, source, and target.

I would like to calculate the X and Y coordinates within the same group. I thought using a batch macro to filter by group would be the way to do it.

Group by ID to run the R tool.png

However, this batch macro created many unnecessary duplicated rows - I'm sure I'm doing something wrong.

Does anyone know how to run the macro contains R tool and calculate the X and Y coordinates within the same group?

Sincerely,

Kazumi

Developer

Macros

R Tool

Accepted answers

patrick_digan

@knozawa I think you need to adjust your action tool to change the simple filter line (you're currently replacing the custom filter which is filled not but not being utilized):

Here is a simpler method to accomplish the same thing: 1) I deleted the control parameter, action tool, and filter from your macro:

2) in the workflow that calls this macro, I would summarize your ID and group by it in the macro:

The control group by is a nice little batch macro feature when you just need to run the data through in groups.

Batch R Network Diagram Coordinates Sample Workflow.yxmc

Workflow.yxmd

All comments

zoeuno

Hi there - I'm so sorry but where can you post question? I have a question too but I can't find the post button anywhere.

knozawa

@zoeuno,

Go to the "Join the Discussion" from either designer or server tab.

Join the discussion.png

Click "New topic"

New topic.png

Then you can create a question.

New Message.png

When you create a question, you need to label your question before posting it.

Sincerely,

Kazumi

patrick_digan

@knozawa Can you post a small sample set of your data as well as your R code? If you can post your macro as well, that would be helpful!

knozawa

@patrick_digan,

I've attached a sample macro workflow.

Sincerely,

knozawa

Batch R Network Diagram Coordinates Sample Workflow.yxzp

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167