Data Studio v2.0 - transform function Map to Target
I will be loading over 15 sources of customer data.
To assist with column naming and tagging the columns l setup a file with all the headings so all data have the same column labels. As part of this heading template l tagged each column.
When l load other files l am using the function map to target to change the headings to be the same as template, saves me renaming all columns and if you add a column or remove down the track can do in template file it maps too. So a big plus.
However, when l map the file to the template file the columns are perfect but does not bring across the tags. Therefore every load of data l have to do the tagging on columns for each and l deliberately added different tags to same column and it just joins them together. Seems l can only do manually and on each file as it loads (annonate).
Is there another way to not have to tag each file?
Any suggestions would be helpful