Forum Discussion
ronaldbalza2023
Continued Contributor
Continued ContributorKey Value Pair - Expand
Hi everyone, how can I expand my data in columns that has key value pairs? It would something to go like this. Thanks in advance 🙂
maybe you can try this
1. split columns by {
2. delete useless columns
3. select job id and unpivot other columns
3. create 2 columns (examples of column) to get ID and name
4. remove useless columns and remove distinct.
ryan_mayu
Super User
Super Usermaybe you can try this
1. split columns by {
2. delete useless columns
3. select job id and unpivot other columns
3. create 2 columns (examples of column) to get ID and name
4. remove useless columns and remove distinct.