Learn, collaborate and solve problems with like-minded data quality enthusiasts.
You can easily get your data from Data Studio into Excel or Tableau using OData. OData (odata.org) is “an open protocol that allows the consumption of data via a simple and standard RESTful API”. If you choose to turn on OData in Data Studio (v2.2.3), you will be able to link your datasets (including snapshots) to any BI…
Hello. I am on ADS 2.8.8 currently and I am facing an issue when trying to load .xlsx as a dataset. Some, but not all floating point numbers are read incorrectly (see screenshot below). I have read the post below and understand this might not be possible to resolve instantly I just wanted to ask that aside from using other…
Dear All! In the workflow I'm running I have loaded a dataset (from excel) containing line breaks. During the worklow I'm transforming the data, but when exporting in .xlsx I'm receiving "\n" instead of the line breaks. Is there a way to have line breaks in the export file instead of "\n"? Many thanks for your help!
Recently I wanted to create a function in Data Studio to calculate the number of working days between two dates, similar to Excel's NETWORKDAYS function. First, a couple of comments: Weekend days are defined as Saturday and Sunday. Being able to handle alternative weekend days (like the Excel NETWORKDAYS.INTL function)…
