nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Two Input documents - Cannot make second document attach to process flow

Archaeopteryx

Hi,

I'm attempting to use two input files in a single Alteryx workflow. One input document is the data input. The second document contains the names and email addresses.

I want to use a separate input document that contains email addresses to send out emails to make the email contacts easier to maintain when changes occur without having to keep editing the workflow.

But I cannot seem to successfully 'introduce' the second input document. Is this something I can do in Alteryx?

Thanks in advance,

Chris

Screen shot of engagement .png

Documentation

Accepted answers

JosephSerpis

Hi @Archaeopteryx you want to do something like this in your workflow using the append field tool. The sample tool is very important as this stops your email recipient receiving an email per every row of data in your output. Mocked up a workflow and attached to this post.

Two_Input_Examples.yxmd

All comments

JosephSerpis

Hi @Archaeopteryx you could use an append tool to join on the stream from the filter and from your select tool.

MichaelSu

Hi @Archaeopteryx ,

Have you tried joining the second input file beforehand with the top data stream and then connecting to the Report Text Tool? The Report Text tool only accepts one input stream. From there you should be able to insert your available fields within the report text tool.

Thanks,

Mike

Archaeopteryx

The two documents do not match in the way of columns and rows. The second document has only two columns Contact Name and Contact Email. The first input file has all the data that is being processed.

My endeavor here is just to make the maintenance of emails easier.

JosephSerpis

Two_Input_Examples.yxmd

Archaeopteryx

Thank you, JS420

The proper use of the Append Fields tool and subsequent clean up is very good intel and it worked for me perfectly.

Thanks again,

Chris

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15905

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703