How can I separate the date and the data? I want to extract in a one row.[ Edited ]
May 2017 - last edited May 2017
Is it possible extract two different data from a one row(META_VALUE)?
(You can check my data sheet sample at the bottom.)
I want to make 'Date' to Time Dimension. "player" to Metric and count it.
(*I can't change or edit the sheet)
USER_ID /META_KEY /META_VALUE
How can I separate the date and the data? I want to extract in a one row.
I would start with creating a calculated field in Data Studio and use RegExp_Extract