Merge Output from Two Modules

[chris99m]

Hi everybody!

I apologize if this is not the place to post this question. If it’s not then I’d be very grateful if you could help me move it to the right place!

I have queried data from the Celonis Query Data Module and then sent this data in the body of an email by aggregating it into a text variable via the Send Email/Skill functionality. This works just fine: (Apologize for the censor)

Now my second task is to on top of that to send a CSV containing the data from the Celonis Query Data Module.

So what I’m looking for is an email (sent by the Send NoreplyCelonis/Email Skill) containing the data from the Celonis Query Data Module in its body and a csv file as an attachment.

I’ve tried:
Celonis Query Data → CSV → Text Aggregators → Email

However the Email/Skill Module has only access to the Text Aggregators variables and not the CSV file. The Text Aggregators also can only access variables from the CSV Module, however I need the variables from the query data in order to build the body of the email.

Is there a way to maybe store the Celonis query data into variables and use it throughout the flow?
Or is there maybe Tool Modules which I can use to allow the Email/Skill Module to get Information/Variables from two modules?

Feel free to ask for more information if my explanation was unclear! Thank you so much!

[samliew]

Welcome to the Make community!

If you set any aggregator’s source module to the (trigger) module, you won’t be able to reference the same module again.

I suggest you set a variable to “copy” the data you need, before/outside of the Iterator/Aggregator “loop”, as depicted by the gray background.

If you need further assistance, please provide the following:

1. Screenshots of full scenario

Please share screenshots of relevant module fields and filters in question? It would really help other community members to see what you’re looking at.

You can upload images here using the Upload icon in the text editor:

2. Scenario blueprint

Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

^{(Note: Exporting your scenario will not include private information or keys to your connections)}

Uploading it here will look like this:

blueprint.json (12.3 KB)

Following these steps will allow others to assist you here. Thanks!

[chris99m]

Thanks for the welcome and the reply!

I’m not able to share the blueprint as it will reveal private info in the Text aggregator modules which I can’t share! And even if I remove that info, the other modules will be empty so it’s basically pointless

Thanks for clearing up the source module settings, that makes sense! Also thank for your suggestion, however I’m not quite sure what you mean with copy outside the gray area?

[samliew]

Use a set variables module to store data.

Don’t aggregate the trigger module if you want to reference it again.

[chris99m]

Hi samliew,

thanks for the suggestion. It however didnt work.
At first I used a set variable to store data from the celonis module:

But when I added the CSV Module, the grey area appeared and I could only access the Output from the CSV Module (and not that from the set variable module as well) in the “Process Automation Skill by Celonis” Module:

Is there any way I could fix my problem like this?

My thought process is to store data in a set variables module on a different path through a router (so it doesnt get affected by the grey are/aggregating module) and then connect that path back to the “Process Automation Skill by Celonis” Module?

Thanks for your time!