We provide three ways to filter your source data and to only transfer a subset to your destination sheet.
This will transfer data from all of the source columns and rows that match the condition that you define.
You can add multiple conditions and combine them. Sheetgo then only transfers the source data that matches all of the defined conditions.
If you are familiar with the SQL syntax, choose "Query language" to define your own custom query statements.
SQL queries are powerful and help you customize the filtering process to the greatest extent. For instance, with SQL queries you can do the following:
As an example, if you need to select only information in the columns A, K and L, use the statement: SELECT A,K,L
For more advanced examples, please check out this article.
This will transfer data where the selected column matched the background color you have specified in the condition. For example, you can bring all rows, where Column A = Blue