<i class="w-icon w-icon-md icon-match-section wk-mr-6 w-pb-4 w-icon-twfr-cube processed" data-section-id="360007220351"></i><i class="w-icon w-icon-md icon-match-section wk-mr-6 w-pb-4 w-icon-twfr-table-wdata w-icon-two-color processed" data-section-id="360007128092"></i><i class="w-icon w-icon-md icon-match-section wk-mr-6 w-pb-4 w-icon-twfr-query-wdata w-icon-two-color processed" data-section-id="360007128072"></i><i class="w-icon w-icon-md icon-match-section wk-mr-6 w-pb-4 w-icon-twfr-view-wdata w-icon-two-color processed" data-section-id="360007128052"></i><h5>General discussion and Q&A about all things Wdata, including tables, queries, and views. For Chains & Connections, <a href="/hc/en-us/community/topics/360001460472" target="no follow">visit this topic</a>.<p><h5>Looking for more in-depth training? Check out <a href="https://www.training.workiva.com/collections/99e41672-dbea-11ea-a9f9-067360dfb065?utm_source=community&utm_medium=link&utm_campaign=lh_help_comm_2021" target="_blank">what's available in the Learning Hub</a>.
I have a query that utilizes the Levenshtein Distance function to test for similarities between employee names and vendor names within our records. Currently all of the query results have a Levenshtein Distance of 2, but it appears that the functi...
When rolling forward a template for the next quarter, we need a way to accurately and easily clear out previous information that the country completed when we rollover the templates for the new quarter. Currently, in order to preserve the live con...
Hi, I am trying to add a calculation field in one of my wdata query to calculated the expected output as original column i.e Amount is taking Cumulative sum for month 2 For eg - for Month 2 the amount should be 1744679.75 but the amount field is ...
How can we migrate tables and queries to Production Workspace from a lower workspace?
I am facing an error while uploading a dataset in a fact table. There is no error log which I can see to identify the issue
Hi, I have a DIM table which have total no of records around 3.5 millions and the limitation of DIM Table is 2 millions, so in case I upload the table as fact table and use in my queries will there be any issues. Is there any other workaround as ...
When trying to manually refresh a spreadsheet connection to a WData query it fails (image below). The connection was working fine previously and no changes have been made to the query or the sheet. I've also checked that the amount of cells retri...
I have a file with these contents: AJE Number,Fiscal Year,Bucket Code,Balance Type Code,AJE Type,Comments 2020-001,2020,A1,ACT,NORM, ,,,,, I am trying to remove the empty row so I have a Filter Rows command as per: Command: Filter Rows Search pa...
Whenever I try to refresh a connection in wdesk for a query with multi-select parameters, I expect to get a prompt to select the parameter value. It turns out that's not the case. Do we have to delete the connection and create it again every time ...
Hi! I'm trying to condition on column value that I've created, using CASE command, but keep gettin an error when I try to call the column in WHERE statment (I've tried "table_nam"."new_column_name" and just "new_column_name", but keep getting same...
I am using a custom sql code and i would like to display my month columns in an order. I am using crosstab view. please let me know if there is a way to do a custom order by column names when using custom sql.
I would like to create a parameter within Wdata Query to always default to current date. I see I can select a date as default value but my requirement is to dynamically update to today's date whenever the query is triggered. is there an alternativ...
I have hiearchial data coming from my source system.I need to create a tree or flattened structure to be able to aggregate within Wdata. I can convert a parent-child hierarchy into a tree using CTE's but recursive functionality is not working in W...
How do I refresh only part of the spreadsheet or only specific cells from Wdata?
When i try to refresh the TB i keep getting a yellow triangle with ! which indicates its a bad request and the TB is not getting refreshed due to this. How can we fix this?
Is it possible to perform basic DML statements such as insert into or update in WData tables via Chains / API? What are my options for modifying data in a Table? I know I can import a file into a table. But if I now want to update all rows wher...
Can I have the data from a spreadsheet linked to tables in Wdata? The updates I do in the sheet should reflect back in the tables in wdata.
How do I integrate my spreadsheet in Workiva with the external DB using Wdata? I have spreadsheet data in workiva. My source is external system from where I want to pull the data into Wdesk. How do I integrate this? Can this be done through Wdat...
When we update our source files from our GL, we can then publish to many other supporting spreadsheets which link together and weave through to our external documents. It would be nice to be able to publish changes to multiple spreadsheets at once...
Not sure how to fix import error... DateEncoder cannot convert "2014"Not sure which format to pick for Year column; everything I try fails the import.
Hi, A little late to the party but one thing I'm not sure about as someone who's team hasn't adopted WData yet is how does Wdata prevent the need for running reports from the general ledger system to check and verify that wdata is pulling the cor...
Hi Experts, I am new to workiva and learning the application. I want to know is it possible to query the data on my Wdata table and whatever result output i am getting has to be added in document stored in WDesk. I don't want to keep results in sp...
In the query's SQL Editor (not Builder), you can use a UNION operator to stack or combine data from multiple sources into rows. However, a union may create more rows than Spreadsheets or another consumer of the results can support. As an alternati...
Can we perform queries to auto-populate a sheet when the source includes new rows while retaining the linking properties in the Destination? Also, any idea on how to build queries to create links between two columns of a spreadsheet?
I am trying to write a query involving string functions of SQL such as 'CHARINDEX' or 'PATINDEX' to check the existence of a particular pattern within a cell data. On executing the query, I get an error saying CHARINDEX function not registered. Do...
Yes, you can use parameters with calculations for both filters and fields. For example, instead of using hard start and end dates in a calculation, you can reference a parameter’s value for the dates or time period. From the Field Properties right...
When you add a filter to a query, you can set its static custom value on the Filters tab. To instead select a filter’s criteria dynamically when the query runs, such as to slice-and-dice data in real time, you can base its value on a parameter. To...
Yes indeed, when you create a filter in a query, its values are case-sensitive. So, if you set a location filter to "Iowa", it returns records with the uppercase "Iowa", but not the lowercase "iowa". To include records regardless of casing: In Bu...
Hi, We are a real estate investment manager and one of the things that our team is responsible for is reporting on all different types of metrics about our properties. We have a large data warehouse that aggregates ~200 metrics for each of our pr...
