Problems merging sheets


#1

This is the situation: I have two sheets in differents files (in Google Sheets). The first sheet has this columns:

IdGroup IdProduct Product Quantity

And the second sheet (in other file) has this columns:

IdProduct Product Quantity

The difference is only one column of the the first sheet (IdGroup). How can I join them with Sheetgo using a query?


#2

Hi @SmartD,

Interesting challenge! :slightly_smiling_face::+1:

I would set it up as follows. Let me know if that works.

https://drive.google.com/drive/folders/18fr1puq8EQv9NU-eGaOsJXG_nQeMs-4x?usp=sharing

image