Compare multiple data bundles against one reference bundle

How To
, ,
1

Hello there, could you please help me out with how to solve the following task:
Let’s say I have a set of 5 data bundles (each separated e.g. by tabs or newlines using e.g. the text aggregator module), where each of these bundles consists of 8 variables (both numerical and text). Each data bundle has a unique ID as first entry.

Now, I have a single ‘reference’ set of 8 variables. I would like to compare this ‘reference’ set against each of the 5 data bundles as mentioned above, and return a ‘true’ or ‘false’ according to certain if-conditions for each of the 8 variables.
So let’s say e.g. in case all 8 reference variables match with each of the variables in each of the 5 data bundles, I will receive 5 ‘trues’ including the corresponding ID’s.
How could I achieve this? Would I require arrays? Or just a hell of a lot if/else-conditions? Also, it could not just be 5, but also 500 data bundles required to be compared to a single reference bundle.
Many thanks for any hints.

2

Maybe share this scenario json so i can understand better
not sure what you are trying to do

2 Likes
3

HI there,
sure, please find attached. We would like to replace the openai-function, as it is not always accurate and consumes lots of credits. Many thanks.

matching-test.json (102.0 KB)

4

Please explain the output
and if you can give some mock data to work with since i dont have any of these apps

TIP: When you aggregate data for further calculation stick to the JSON format which will be easier to work with in the rest of the scenario

2 Likes
5

Welcome to the Make community!

If you need further assistance, please provide the following:

Screenshot_2024-02-28_090225

Please provide the input and output bundles of the above two modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.
Screenshot_2023-10-06_141025

A.

Save each bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

Uploading them here will look like this:

module-1-input-bundle.txt (12.3 KB)
module-1-output-bundle.txt (12.3 KB)

B.

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles in this manner:

  • Either add three backticks ``` before and after the code, like this:

    ```
    input/output bundle content goes here
    ```

  • Or use the format code button in the editor:
    Screenshot_2023-10-02_191027

Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

This will allow others to better assist you. Thanks!

2 Likes
6

Many thanks. Unfortunately, I can’t upload the bundles as .txt files are greyed out in the upload dialog. However, pls find the google-drive link to the bundles below:

download link to bundles