Data Studio offers a number of ways to transform your data in various ways. You can either use:
Join two inputs into one based on one or more columns from each input.
To specify the columns you want to join, click Left side columns or Right side columns.
Use the Retention type menus to specify different combinations of join. The top menu is for the first join input and the bottom one for the second join input.
Click on the Venn diagram to specify the type of join you want to apply:
Above the Venn diagram select More options to expose more detailed options for the join.
The Join step provides three matching options which determine how keys will be compared:
The Do not match nulls option configures how null values are handled in the join. When enabled, left or right column values containing nulls will never match with any other row. This means that rows where the join key contains nulls will never appear in inner join results and will always appear in left/right unmatched results if the selected join type will include left/right unmatched rows.
In the join dialog, click Show step results to view the results of the join. Specify which values from the joined columns to use in any following steps: all the matches, only duplicates or only singletons.
Click to see suggested join keys. Joins will be suggested only where column names match exact on the two side of the join. Click on the suggested join to apply it.
Filter your data using a function that returns a boolean (true or false) value. If the function returns true, the given row will be passed through to the step output.
Group and aggregate column values.
Grouping allows you to group values from one input into one or more columns and aggregate the remaining columns, if required.
Click Grouping in the step dialog then drag and drop the required columns up, into the Grouped list. Remove columns from this list by simply dragging them down. Click Apply when done.
You also configure grouped columns and use aggregate functions on the grouped values when in Show step results view: right-click on the grouped column heading and select Add aggregate. In the dialog that appears, specify the name/description for the new column, the source column to be used for aggregation and the required function.
You can drill into a particular group to see the rows that belong to it by exploring the results, selecting a particular group, right-clicking and selecting View rows in group.
The ability to drill down into the Group step results will be retained if the step is connected to any of the following subsequent steps:
You can view the drilldown using the right-click options or the toolbar on these steps.
The results of the grouping can be saved to a Dataset by including a Take Snapshot step in your Workflow. Furthermore, if the Interactive option is selected when creating a new Dataset on the Take Snapshot step, you can drill into the data to view the rows in each group in the Dataset.
Once an interactive Dataset has been created, it can be drilled into in various ways, such as:
Interactivity also works for multi batch Datasets.