Filtering based on 2 CSV

Questions & Answers
1

Hello everyone,

I am building a scenario which aim to do this:

  • Trigger: webhook in a glide app (I pass through 2 csv, one with all the user’s email of the app, and the second with email to add)
  • Add a row in my user glide table if the added user doesn’t already exist.

My scenario looks like this:

Capture d’écran 2023-06-19 à 17.50.30
Capture d’écran 2023-06-19 à 17.50.302670×570 136 KB

But I can’t find a way at the end to filters in order to only add email from the second csv, that doesn’t exist in the first one.

Capture d’écran 2023-06-19 à 17.50.40
Capture d’écran 2023-06-19 à 17.50.401152×1706 261 KB

Capture d’écran 2023-06-19 à 17.51.00
Capture d’écran 2023-06-19 à 17.51.001208×1572 149 KB

Thanks for the help!

2

I think you can try to iterate the items and then filter the matching ones

2 Likes
3

Thanks for your help, I put a filters and now it works, thanks a lot!

After that, I want to join a string (composed of emails separated by comma, send through the trigger webhook) and values from an array (emails, the ones that passed through the filters).

I need this final list of email to edit data in a glide DB.

Here is the scenario and data from my last aggregator:

Capture d’écran 2023-06-20 à 12.53.57
Capture d’écran 2023-06-20 à 12.53.572544×242 117 KB

Capture d’écran 2023-06-20 à 12.54.08
Capture d’écran 2023-06-20 à 12.54.08902×1012 84.7 KB

This would be very helpfull, thanks in advance!

4

Hi @Kalu,

What you can do is,

  1. Either use the Join function with the Map function in the array aggregator

join(map(Aggregrator Array; Column 1);,)

  1. Or, Use Text Aggregator instead of Array Aggregator and join the email by comma
2 Likes
5

I’ll try that, thanks for your help!

I’ll keep you informed :wink:

6

I added a set variable after the aggregator (couldn’t find how to add the join function in the aggretor) but it only gets my commas:

Capture d’écran 2023-06-20 à 13.09.29
Capture d’écran 2023-06-20 à 13.09.291018×850 57.1 KB

Capture d’écran 2023-06-20 à 13.09.34
Capture d’écran 2023-06-20 à 13.09.34964×924 60.2 KB

7

Something like this,

Screenshot from 2023-06-20 16-57-30

Column 1, needs to be typed, you can hover over the Array Aggregator result, on Column 1 and it should display a raw value, which I believe is Column 1.

1 Like
8

It works !!

In order to add mails (sting, separated by comma) to it, the best it so add it to this variable afterward or can find a way to directly join them all the this variable?

Thanks a lot, impressive!

9

You can directly do that where you want to use the output, for eg, if it is a GSheet Module , you can add it on the desired column.

If aggregator is not doing other thing beside gathering the Email, then maybe you can use the Text Aggregrator instead.

2 Likes
10

Everything works, thanks a lot for you help!

1 Like
11