Forum Discussion
Extracting the first comma separated value to a new column
This seems like it should be easy but I am having a bit of trouble. I have a list of clients each client has multiple servers. Each server for that client has the same specs and I have a separate spreadsheet with Specs on it.
So to join the two together I just need one common server.
The Webserver column lists the servers as "Server1,Server2,Server3"
I want to extract Server1 only for each client and populate a column called FirstServer. I can then join on that value to add in the specs for each client. Hope that makes sense :)
In addition: if you want the result in a new column: choose Extract in the "Add Column" tab.
In the Extract submenu, "Text Before Ddelimiter" should suit your needs,
5 Replies
Hey Buddy.
You can use the "Extract" function, under the Transform tab in the query editor. This function allows you to choose the separator, in your case, the comma.
Hope it helps
Regards
- MarcelBeug
Community Champion
In addition: if you want the result in a new column: choose Extract in the "Add Column" tab.
In the Extract submenu, "Text Before Ddelimiter" should suit your needs,
I am new to using PowerBI Desktop and I only see Home and Modeling tabs. Do I need to add tabs in options some where?
- MarcelBeug
No, you can choose "Edit Queries" on the Home tab.
Then you will see the tabs and options we mentioned previously.
