<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>.
Hi all, Starbucks Financial Reporting currently uses Workiva Wdesk for our SEC reporting solution. Our process has been fairly manual and we took steps this year to embrace import and synch functionality as incremental improvements. We are in pro...
Is there any kind of data model template for Wdata for financial reporting? I'm not talking about Chains, but rather tables, their relationships with each other, and their queries, so as not to start the data model from scratch.
Has anyone developed an effective process for electronically reflecting the tieout of information in WData? There is a "Markup Tool" in the document that contains a tickmark legend and other typical tieout symbols, but it is not available in WDat...
Our team is aiming to update column names for some of our tables. These tables and columns are used in queries downstream. Will we have to update the column names downstream as well or will they automatically update? How is the column ID used in d...
Hello, I just watched the “What’s New from Workiva: AI Extensions, Workflow Management, and More” webinar. We use Workiva AI today, but I don’t see the Wdata AI features shown in the session in our environment. Could you share the expected timelin...
Hi, we are currently using Wdata to pull data from our ledger into our excel file in Workiva to feed into our 10Q/K. Currently, how this is built is once we run the chain, refresh the connection, we have a data dump in our excel file in Workiva. W...
Hi Workiva Community! 👋 We've built a free tool to solve one of the most common headaches in Wdata and Chains: getting date formats right. Whether you're creating a new Wdata table or writing a date transformation in Chains, finding the correct fo...
Hi. I am having an issue on my query and showing (blank) instead of 0 (zero) even if I set he column decimal. is there any way to change "(blank)" to 0 on my query using Builder?
Hi I've managed to use chains to delete the latest data set in a table however If i wanted to clear the whole table how would i do that? As a bit of background manually we would upload 4 different data sets into one table at month end we would ...
We are currently having issues converting "(Blank)" values in Wdata into null values. We tried using numerous case statements and multiple functions to convert (blank) values into null values, but the output returns "(Blank)" values again. Are the...
Hello! I am attempting to create a query using data from two tables. I would like to add the new rows based on position (union the two sources to add rows instead of joining based on a key). Is this possible? I tried using the UNION function in th...
Is there way to write hierarchy query on wdata table ? I have a table with parent, child relationship information. Would like to write query to display hierarchy. Does Wdata support connect by prior as in Oracle database or Recursive common table ...
Hello All We have an MDX query which shows only the text column and no key. But the same query when executed in Analysis for Office and RSRT in BW works fine. So would like to know if there should be any settings performed to run the MDX query to ...
I am creating a copy of a file but want to keep the links to source files and all incoming and outgoing connection. If i select all connections when making the copy of the spreadsheet does it also give new connection IDs to the incoming connection...
Hello I want to know how to use the SQL Distinct to get unique details. Suppose if they are two same URL's in the spreadsheet i need to get the unique one.
In Financial Reporting (A&I and GSR reporting workspace), want to know which roles are used for Wdata and which roles is used to Wdesk separately to show the difference
I have for example a table with the sales per country and per product: Product Country SalesApples DE 100Orange NL 50Apples BE 100 Now I want a query that shows the result per product of N...
I am trying to make sure I understand the key relative benefits of using a shared query to share data between workspaces vs. using a connected data set. Here's what I came up with, but any feedback, input, corrections, or additions would be apprec...
Is there a way to use WData to query user activity? I can export this manually from the Workspace Settings, Activities tab, but would like to do this more programmatically.
My query data includes fields 'year', 'period/month', 'category' and 'sales'. I would like to create a field that gives me a running, YTD, total of 'sales', by 'period/month' and by 'category'. How can I achieve this within the Workiva SQL platfo...
Hi all, I am trying to query details about the SCHEMA that I have on Wdata. Does Wdata allow this ? because I tried a simple query to list all the tables in the current schema (SHOW TABLES;) but I am all time getting error. Can somebody advice co...
Is it possible to use sub queries other than using the WITH clause and UNION? If so is there a special way to use sub queries?
Is there a way to specify the order in which query parameters appear in a data connections?. I have one main query with 5 parameters and several sub queries that use the source query parameters, But in each subquery, the order in which they appe...
I'm trying to format my data to be "Number / Number". It works when I run the query, but when I connect it to the spreadsheet, the spreadsheet formats it as a date and when I try to change the format to text it gives me the date code. What ca...
Trying to connect a Wdata query to a spreadsheet in Wdesk. I've been able to do this with other queries but all of the sudden, I'm getting an "Update Failed" message due to cell limits being hit. When I run the query in Wdata, I only get 45,000 re...
Hi, In one of my queries on Wdata I am getting the error (cannot cast to INT"000OCI") that is understandable since can't cast character to INT. However the field where I am using the cast function does not have any record that contains such a valu...
Good afternoon, I am new to WDesk, i am trying to map an account. Can anyone led me in the right direction. I tried goggling and it just makes it more confusing, Any tips, and advises are appreciated. Have a great day, Thank you Monica
I've been testing "the possible" with Wdata using CrossTabs. I have a dataset that is a matrix of sorts. It is 256 columns X 27,000ish rows. I would like to make a simple Income Statement (Full disclosure.. Camel's nose in the tent... once I get...
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...
