Join two data sets by year in Tableau -


i have 2 datasets looks like:

# 2013_data.tsv year    state   age 2013    ca  22,5 2013    oh  19,3 2013    il  45,5 2013    tx  33  # 2012_data.tsv year    state   age 2012    ca  23 2012    oh  21,5 2012    ca  44,3 2012    tx  34,4 

i want use year pager on tableau map.

how can join separate data sources?

you blend on year, if year different in each data source blend not match on , no results.

i guessing each data source (tsv file) has same format (same number of columns , column names). in case can extract each data source tableau desktop , add data each source master extract. (you appending data extracts):

enter image description here

and data in 1 extract:

enter image description here

from here simple combine years in 1 visualization.

also, since so, point out can programatically extract api (see https://www.tableau.com/learn/tutorials/on-demand/extract-api-introduction).


Comments

Popular posts from this blog

css - SVG using textPath a symbol not rendering in Firefox -

Java 8 + Maven Javadoc plugin: Error fetching URL -

datatable - Matlab struct computations -