Not sure what you are trying to do.
Are you trying to derive col2 based on col1, what join you want to do here?
Hi, good to see your response.
I was actually trying to create multiple data sources with defined join condition like
Data source 1 with all data where Table1.Col2 contains "AAA". We do have ten segments like this. We thought of create ten different tables and connect but I was looking for the option if there any dynamic option if I select A in Table2.Col1 the we get only data related to AAA.
Appreciate for your help.
So yes if there is a "pattern" you can define (such as in your example where 'A' is the first character of the join string 'AAA'), or if more complicated, and you only have 10, you could create an IF Statement as Ankit has shown
I have tried to do the same as you mentioned but first of all I was not able see the custom join option 'Create Join Calculation'. I am using Tableau 10.0.0 version.
To make it clear, I was mentioning accurate table data and the scenario what I am looking for.
Division EPAY DC FRS BANKSOL CUS BILLER FINANCE
CLIENTID DIVISION 1 DC,EPAY,FRS 2 EPAY,FRS,FINANCE 3 FINANCE,DC,BILLER 4 BILLER,EPAY 5 FINANCE,FRS,CUS 6 CUS,EPAY 7 FRS,BILLER,EPAY 8 DC,FINANCE,FRS 9 BILLER,DC,BANKSOL 10 BANKSOL,EPAY,DC
Here I wanted to create join between Table 1.Division = Table 2. Division like
if Table_Division.DIVISION = 'EPAY' THEN Table_BUREFERENCE.Division contains 'EPAY'
if Table_Division.DIVISION = 'DC' THEN Table_BUREFERENCE.Division contains 'DC'
if Table_Division.DIVISION = 'CUS' THEN Table_BUREFERENCE.Division contains 'CUS'
and so on...
How I wanted to use this in reporting
In reporting I will be using Table_DIVISION.Division as Filter and created couple of objects considering Table_BUREFERENCE.
When I select DC in filter all charts show data with respect to DC and when in select FRS in filter then all charts show data with respect to FRS and similar with other selection options.
I try to import two tables as two individual data sources but still not able to connect both with no common column
Please advise me how to proceed, it was so important for us to go forward.
Ok this feature is available only from 10.2 version onward.
May I know what is your data source? excel, database? Because somehow we need to join 2 data sources. If possible we at least need to create a dummy column in both the sources with value just 1 for all the rows. After that we can do workaround to achieve the scenario.