Forum Discussion
Can't separate a field by delimiter while using direct query
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?
Im not sure what you mean by this, The current SQL looks like
"let
Source = Sql.Databases("efsdb.database.windows.net"),
efsdb = Source{[Name="efsdb"]}[Data],
dbo_WorkItem = efsdb{[Schema="dbo",Item="WorkItem"]}[Data],
#"Duplicated Column" = Table.DuplicateColumn(dbo_WorkItem, "WorkItemPath", "WorkItemPath - Copy")
in
#"Duplicated Column"
Ignore the duplicated column query
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?
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?