Forum Discussion
Extracting String From Column into New Column
Hi Anonymous ,
Once published i have seen last row of your question where it is said that direct query is used. In this case, the best option is to make this column on database table level.If Power Query (depending on database) allows extract options, below are steps:
Select the column (Issue Title) > Extract > Text between delimiters
For delimiter enter space.
Cheers,
Nemanja
Hi Anonymous ,
Once published i have seen last row of your question where it is said that direct query is used. In this case, the best option is to make this column on database table level.
If Power Query (depending on database) allows extract options, below are steps:
Select the column (Issue Title) > Extract > Text between delimiters
For delimiter enter space.
Cheers,
Nemanja
nandic ,
I appreciate the prompt response. Unfortunately I get the error "this step results in a query that is not supported in DirectQuery mode" so I am unsure if it is successful. I will see if I can import the table and will retry your solution.
Anonymous , in this case there are two options:
1) adding this column in database table
2) importing this table, as you suggested. In that case, steps from above will work.