Suppose I have imported Avro/JSON data into a flex table and the data is flattened. There are many 'keys' in the raw column that are available as virtual columns. As a convoluted example lets assume some of the keys are:
person.salary
person.name.firstname
person.name.lastname
person.name.nickname
person.name.title
person.favourite.colour
What I would like to do is to select only and all of the data with keys like person.name.*
i.e. return data like:
| person.name.firstname | person.name.lastname | person.name.nickname | person.name.title |
|---|---|---|---|
| bob | smith | bigguy | mr |
| jane | jones | ace | mrs |
I know I can do this by explicitly listing all the virtual columns, but let's assume I don't know all of the keys that could have been added under 'name'.
Is there any way to execute this and return this subset of the data? I'm hoping to wildcard/like the key name.
Thanks,
Robert.
