How to create new columns from compound values in a column with Power Query?

[Zelbinian]

The data I have has a column called "Tags" that I need to transform into something more meaningful.

The "Tags" column is plain text and has contents that look like this: #store-aisle-product

There are other values in the Tags column as well, but this is the only one I care about. So what I need to do is the following:

1. Isolate that tag
2. Create a new column for the store, aisle, and product, respectively

I've been looking at the documenation and some examples here for various split and add column functions, but the Power Query syntax still reads like so much Greek to me 😞

[Anonymous · Accepted solution]

Hey @Zelbinian

Try out the Column From Examples option in the Query Editor. It's codeless and you can tell Power BI which part of the field that you would like to extract and it can then infer from a couple of examples what it should do for the rest of the records. Give it a try and let me know if it works for your case!

Parker

[Zelbinian]

Well that's some straight-up witchcraft. Thanks!