PatricioSanchez Unfortunately, we don’t currently have a way to create independent queries prior to merging.
The closest workaround would be to create individual connections that would do this mapping. Example:
Connection 1 -> File 1 to Google Sheets or CSV with Filter:
Select B, D, E, F, G
Connection 2 -> File 2 to Google Sheets or CSV with Filter:
Connection 3 -> Results from connections 1 and 2 Merged into a destination, no filter required.
@Willian from Sheetgo any other ideas?