joining tables dynamically

Hello everyone,

I'm trying to join two tables dynamically on a variable number of fields, so I built a batch macro that allows me to input 2 tables and a text string.

This text string is used in the macro to update the raw XML.

I'm new to this so I probably screwed it up (well obviously since it's not working), but I can't figure out what.

Could somebody please have a look why the batch macro is not outputting the right result? I attached the workflow that i got so far.

Huge thanks in advance,

Mikis

flexible join question.yxzp

Workflow

Macros

Transformation

Join

Accepted answers

CharlieS

@Mikis

Solution Attached. I crudely reconstructed the Outer XML from the Join tool in the macro with the Text Inputs. Let me know if you have any trouble opening the file.

EDIT: Another thing that should be added is a Dynamic Select tool after the Join tool inside the macro with the following formula. It will deselect any field that are renamed with the prefix "Right_" due to duplication between inputs.

IF left([Name],6)=="Right_" THEN "false"
ELSE "true" ENDIF

20180515-joining via batch macro-CS Edit.yxzp

All comments

ddiesel

Hi @Mikis

I was going to take a stab at answering your question, but I get an error when trying to open the workflow.

There was an error opening "C:\Users\x\Downloads\flexible join question\joining via batch macro.yxmd":

This workflow was created by a more recent version of Alteryx, and may contain tools or functionality not present in this version. Alteryx does not support using an earlier version of Alteryx to open a workflow created with a newer version. For best results, download the latest version of Alteryx.

Do you still want to attempt to open the workflow?

I think I'm on the most recent version of Alteryx Designer: 11.7.4.37815. What version are you on?

CharlieS

@ddiesel

The workflows were built in v2018.1. If you open the module and macro in a text editor like Notepad, you can just change the "2018.1" here to a lower version like "10.5" and it'll work in most cases where newer features are not used.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703