Yes. You have to resolve this error.
In the reference...
> Data Blending does not create row level joins
> With a left join, the view uses all data rows from the primary data source
So... the Data Blending works always the level of a primary data source,
then the calculation from a secondary data sources must be specified with how to aggregate into the level of a primary data source.
In this case, the following steps provide your solution.
1: create calculated fields on the filterSource base on user login name
formular: username() = [filterSource].[name]
Step 1 is the same as your step.
2: active the relation link of the field [filterSource].[filterCol2] by using the data source [filterSource] as the secondary data source
3: add the step 1 calculation into filter and select 'TRUE'
The point is join key is set in relationship not set in calculation,
in order to join and filter together.
Thanks a lot for your reply! Pretty much all I want to know are all here.
Question on the second step, after U choose the dataSource as the primary source and filterSource as the secondary data source, tableau treating filterSource as the primary and dataSource and the secondary. Do you have any idea on this?
Thanks a bunch!
Just put any field of the primary source at first.
Then if you remove all fields of the primary source, it will keep as the primary.
(Of course, if you remove all fields of all source, it'll be initialized at all.)
Thanks a lot! Appreciate your answer!