Alteryx database schema

Hi community,

I want to input four alteryx databse( two from alteryx, one from mongodb and one from salesforce) together using '*' character in input tool connection. Now, the 4 databases have same columns but in different order and thus, different schema and only first one was inputted, the rest were skipped.

I want to alter the fields' order so that they all have same schema and I can input them all together using '*' character.

How can I do that? Kindly help! Thanks!

Datasets

Input

MongoDB

Database Connection

Salesforce

Accepted answers

All comments

It sounds like they are all different file TYPES, in which case you can't use one input tool with the asterisk. Some screen shots might help.

@Tripti_Lal
With the Batch Macro and Dynamic Rename, we should be able to do the trick.

The sample is using Alteryx datbase, but it should apply if the data is defferent as well.

The macro is reading the full path of the data file.

Please download the zip file and configure the input accordingly.

1117_Tripti_Lal.yxzp

@mbarone Thanks for the reply,

I am attaching the four databases that I am trying to input.

Kindly let me know where I am going wrong in inputting them all together.

AlteryxDollar.yxdb

DateTimeDollar.yxdb

SFDCDollar.yxdb

MongoDollar.yxdb

Thanks for your comprehensive solution.

I am still a beginner and have to learn about macros, but would definitely try this out once I am through with macro modules.

I have also attached the 4 databases I am referring to for further exploration.

If there is any other method, kindly let me know.

Quick Links

Unanswered
Community Events
Groups

Tags

This months top contributors

AkimasaKajitani 387

Hollingsworth 335