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?
Microsoft EmployeeCan you adjust the SQL you use to query the table to pivot the data into rows? Using CROSS APPLY or similar?
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
v-chuncz-msftCommunity Support
Anonymous,
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?