Forum Discussion
Solved
Regroup Values to make less objects showed in Column Legend?
Hello: I have a dataset similar to below: cost date name 100 2022/6/13 main-name-1 101 2022/6/13 main-name-2 102 2022/6/13 main-name-3 103 2022/6/13 subname-a-1 10...
kuma
I hope this is what you're looking for https://www.dropbox.com/t/hj5rU1wIXUuMrtCX
tamerj1
Community Champion
Community ChampionHi kuma
Little confused. Would you please have the four examples in a table showing nput in one column and output in the other column
| Input | Output |
| MC_Corp-Platforms-RESOURCEGROUP-01-RESOURCES_AKSDEVTEST01_USEAST2 | ? |
| databricks-rg-ADBDevTest01-8vcbrmn9wnqks | ? |
| Corp-Platforms-RESOURCEGROUP-01 | ? |
| "Others" | ? |
Hi @tamerj1
Here are the examples what I want to get values output in the new column.
Please tell me how to archieve this,
Thank you very much.
| Input | Output |
| MC_Corp-Platforms-RESOURCEGROUP-01-RESOURCES_AKSDEVTEST01_USEAST2 | AKS |
| databricks-rg-ADBDevTest01-8vcbrmn9wnqks | ADB |
| Corp-Platforms-RESOURCEGROUP-01 | Corp-Platforms-RESOURCEGROUP-01 |
| "Others" | Others |
- tamerj1
kuma
I hope this is what you're looking for https://www.dropbox.com/t/hj5rU1wIXUuMrtCXHi @tamerj1
Thank you very much.
This solution you provided can solve my issue.