Forum Discussion

msimmonsmcse's avatar
msimmonsmcse
Icon for Helper I rankHelper I
6 years ago

Separating multiple URLs into separate links

I am working on a report that injests a CSV file for its data source. One of the column has URLs to related websites. Some of the rows have up to 13 URLs, seperated by a comma. When I put this into a...
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Split it by comma as you did then select all of the resulting columns and Unpivot.

msimmonsmcse's avatar
msimmonsmcse
Icon for Helper I rankHelper I
6 years ago

This created 25% more rows. What I was looking for is a way to seperate each value into a single link, but keep them all in the same cell.