Forum Discussion

reetu_k's avatar
reetu_k
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Split Columns using delimiter in direct query mode

I have a direct query and have the need to split my column using a delimiter like '_'. Since I am in the direct query mode I am not able to use the split column option. I want a new column with data ...
Need Help
reetu_k's avatar
reetu_k
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Hi 

 

Unfortunately this did not work for me as Search returns the position of the '_' from the string - So I am getting a numerical response back

dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

Hi reetu_k , 

As I know, find and search can't used in calculated column when you using direct query, so I think you could try to use t-sql query to create the split column when you use direct query.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.