Tableau Consulting — A Tableau Consultant POWERING UP! “manual data entry on a table”
There’s a way to synthesis data into a query… But I call it the glass legs of your solution. I’m thinking answering this with an example; VS helping with this scary crosstab, might be better usage of my time. And i hope it helps you…
Don’t let this be your hammer…. It’s just a savy SQL trick. And data should be manipulated BEFORE you get it, otherwise you’re asking Tableau to be an ETL product, and your DBA, MANAGER, and maybe even some sort of weird compliance law that I don’t know jack about.
It works great, and it can also be a big glass LEG to stand on.
Here I want to get May and Jun in the table above. Pretend it’s not there, and the query below gets it there!
QUERY is our reporting flag, and we know what it points at, you want to turn these into integers, and have a mapping document that clearly explains what those integers are, but before i get too deep in optimization, let’s get to the query.
Let’s rock…
Synthesizing data in a SQL query
select
month,
integer,
‘table’ as query
from TableA
union
select
‘May’ as month,
5 as integer,
‘synthesized’ as query
union
select
‘May’ as month,
5 as integer,
‘synthesized’ as query
Don’t make this your only hammer. But it absolutely will implement data into a table, to be utilized at your disposal.
This solution came from a solution I made in 8.0 -> because dynamic parameters are a thing (that you don’t want to manually deal with EVER EVER NEVER). And it also solves many to many, which stems from a need for global filters -> which until V10 you didn’t have a ‘all related datasources’
You will need to cast anything that doesn’t have the same data type. Ask your DBA for help if this seems crazy. Sorry in advance if it’s far off, but what I’m seeing is “MANUAL DATA ENTRY” and that’s a ‘nope taco’ in tableau.
Sorry i have a weird sense of humor. Otherwise this would not be fun to read, and I think it’s actually really fun to know how to solve the #1 most requested idea for YEARS. Thanks for your time.
Best,
Tyler
Dev3lop
We offer advanced content on the TableauCommunity too.
We offer fun community challenges. Solutions to many to many using basic SQL.
Some call it a solution to dynamic parameters — which is the most requested product feature!
Also, we spend a good deal of time offering product feedback. We really know the product and love helping the community forum with all kinds of challenging usecases.
Come catch up:
Comments