Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.
SOLVED

TFS to Excel - Removing Selected Carriage Returned

Highlighted
Meteoroid

Regrettably, no.  There is nothing uniform about the data we get out of TFS because too many people are entering and not adhering to any sort of rules.

Alteryx Partner

@jbarnabyquotes should not be inserted by users, but in the DWH.

 

I am not an TFS expert, but you should be able to write some SQL in the database before export the data.

 

something like that:

 

SELECT '"' + comments + '"' FROM table

 

This link might help you to interact with your data before export them

 

https://www.visualstudio.com/en-us/docs/setup-admin/tfs/architecture/sql-server-databases

Highlighted
Meteoroid

Thank you!  I will look into that.

Labels