Tableau is for data analytics - not for data input. So we are not able to enter a new column in a data set that does not exists already or can't be derived. (If the join info can be derived then you can use it for a join) .The we I read your question you would like to use Tableau for data entry.
If you have MS Access you can use that for creating a mapping table between your tables (you can create linked tables in Access based on SQL tables). Else you can use the old fashioned way of using Excel :-). Not recommended - but sometime okey for quick and dirty solutions.
In tableau you can de data blending. It works like lookups in Excel - just much faster.
Hope it helps
Thanks Peter. I've been working with Tableau for a few weeks but have immediate issues to solve. I saw the Tableau PDF manual that looks like a good place to build a basic foundation (all 900+ pages of it).
1 of 1 people found this helpful
I have been using tableau for the last 3 years - and i'm loving it :-)
My suggestions are:
- Watch the videos under Learning
- Use Tableau on a specific project or specific task that you have to deliver on
- Use the forums
- Attent the customer conference - if you can get your employer to pay :-) It is great value for money. Great fun and lots of input and ideas
- Just use the manual for references
Welcome on board :-) and i'm sure you are going to like it.
Depending on what you need, yes you can add some things using custom MySQL queries.
If you need specific values for each row it may be too much work, but if you just want to add a column with some name and one or a few values that you use to join on, it is definitely possible.
I'm working with Tableau 8. Don't know about 7.