Forum Discussion
One column to many registries
Hi guys,
I have a table like this:
| Story | ID |
| 1 | A20CAD-1330 |
| 2 | A20ST-208 |
| 3 | A20CAD-980&A20CAD-996 |
| 4 | A20QUO-89&A20QUO-2&A20QUO-8&A20QUO-9&A20QUO-11&A20QUO-14 |
| 5 | A20COT-61&A20ST-273 |
| 6 | A20PDP-942&A20PDP-732&A20PDP-733&A20PDP-780&A20PDP-935 |
| 7 | A20PDP-497&A20PDP-749&A20PDP-760&A20PDP-767&A20PDP-768&A20PDP-769&A20PDP-770&A20PDP-772& |
| 8 | A20PDP-770 |
| 9 | A20PDP-716 |
| 10 | A20PDP-697&A20PDP-685&A20PDP-355&A20PDP-515&A20PDP-553&A20PDP-680&A20PDP-681&A20PDP-682&A20PDP-683 |
| 11 | A20PDD-46 |
| 12 | A20INT-428&A20INT-765&A20INT-766&A20INT-767&A20INT-768 |
| 13 | A20INT-78&A20INT-80&A20INT-89&A20INT-94&A20INT-104&A20INT-106&A20INT-107&A20INT-229&A20INT-302&A20INT-633 |
| 14 | A20COT-464&A20COT-466&A20COT-469&A20COT-470&A20COT-472&A20COT-473&A20COT-475&A20COT-477&A20COT-479&A20COT-482&A20COT-485&A20COT-486 |
| 15 | A20COT-24&A20COT-413&A20COT-23&A20COT-405&A20COT-407&A20COT-408&A20COT-412&A20COT-451 |
| 16 | A20COT-413& |
... and I'd like to transform each registry in various. It's separated by "&"
Ah, then you should be able to use the solution here for your needs:
3 Replies
- Cmcmahan
Resident Rockstar
In the Home tab, go to Edit Queries. This will open the query editor window. Select the table in question, and in the Transform tab, there is an option to Split Column > By Delimiter. Split by &, and you're done!
- Cmcmahan
Ah, then you should be able to use the solution here for your needs: