Aggregate REST URLs

[kalcey]

I am looking to aggregate a list of URLs by their prefix.

say a list of these prefix goes like this:

Get url1/action1/

Get url1/action2/

Get url2/action/

Post url3

and another list:

Get url1/action1/36465

Get url1/action1/95667

Get url1/action2/i58483

How can I map a prefix to all of its calls, in order to run an aggregate query?

Thanks

[v-shex-msft · Accepted solution]

Hi @kalcey,

You can use below formula to get the prefix part of url string:

#"Added Custom1" = Table.AddColumn(Source, "Custom", each Text.Range([Column1],0, Text.PositionOf([Column1], "/", Occurrence.Last)+1))

Screenshot:

Regards,

Xiaoxin Sheng