Start a new topic
Solved

2 date columns and Data Studio

Hi,

I made 2 different queries in the same Google Drive Sheet to pull data into the same Google Data Studio table. 


Problem is, each query create "date" columns, so this duplication causes an error into data studio. 


When a replace the header "date" with "Date2'. All works weel! I tried to make this cell protected, but refresh query always overwrites the modified cell. 


Any suggestion to prevent rewrite a particular cell? I can't simply not use header row because columns order can change (based in client list).


Thank you!

1 Comment

Hi Bernard,


I suggest that you use headers only in the first query, or not at all. If you start the query from the second row without headers, you can set up headers in to the first row as you wish and they wont change because they are not part of your queries:


image


Best regards,

-Supermetrics Team


Login or Signup to post a comment