1 Reply Latest reply on Sep 12, 2018 5:21 PM by Esther Aller

    how to use USERNAME() function or [TableauServerUser] parameter in custom SQL

    Tableau Learner

      I have two tables in data source, we could either directly join or convert into a custom sql.

      Requirement is to filter the data by a login user in only one of the tables(not in both tables).

      As we know, we cannot use "Filter" option in the data source as it applies to complete data set.

       

      I tried using custom sql but, USERNAME() function or [TableauServerUser] parameter are not working here. Please advise.

      FYI, I also used blending (by having each table in each data sources and use Filter option) but blending has few limitations which may not work for me.