Forum Discussion
Can't separate a field by delimiter while using direct query
Hi Everyone, Hoping for a solution to this one. I have a field coming from a sql server using direct query that looks like this: 001|568|222|448|78456|1145 I need to find a way to seperate ea...
The sql function you refer too would create many new rows of data, I am looking to split the Path into columns. Do you have any other recommendations?
v-chuncz-msft
Community Support
Community SupportAnonymous,
You may specify SQL statement in the Advanced options.
https://docs.microsoft.com/en-us/sql/t-sql/functions/string-split-transact-sql#examples
The sql function you refer too would create many new rows of data, I am looking to split the Path into columns. Do you have any other recommendations?