-
Lag() function for previous value over unpredictable rows counts of each partition
Hi Everyone, I have a dataset with a monthYear date field, a Quarter field with values 1-4 to represent quarters, and finally a quarterly_value column. Here's where it gets fun. Not all months and quarters are present in the dataset. There will never be a monthYear with more than one row (i.e. never two rows of DEC 2023).…
-
How can I update row values for col1 based on the common ID in col2
How can I use MagicETL to update the rows with NULL Source values to have their relevant Source value, based on ID? Starting Table ———————- Source | ID | RankCol ———————- plant | 100 | 1 NULL | 100 | 2 animal | 101 | 1 NULL | 101 | 2 Desired Resulting Table ———————- Source | ID ———————- plant | 100 | 1 plant | 100 | 2…
-
Google Ads connector - Location tab - Geographic View Report
Hello, I brought in some simple data from the Google Ads Geographic Views report. Something as simple as metrics_clicks or metrics_impressions are not matching the UI's Location tab, under 'Targeted Locations'. The strangest part is the clicks and impressions match (connector and UI) for some of our Client Customer IDs,…
