Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Dec 7, 2022, 3:39 PM

Merging ID columns from seperate data sources with a calculated field?

Hi everyone,

 

Was hoping someone can help me with creating a calculated field that allows me to merge ID columns coming from seperate data sources?

 

I can't union or join since one of the data sources is a published tableau server extract.

 

I just want all the rows in each column combined into 1 single column so I can blend on a different field they have in common

 

Thank you!

2 answers
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    Dec 13, 2022, 3:27 PM

    I don't have access to Tableau prep :(

     

    Is there no workaround that exists that bypasses the "cannot mix aggregate and non aggregate" error message I get when using columns from different data sources?

     

    I thought of using the ZN function to return a column that checks if there are any matches in between the 2 columns. Since there aren't any it would return everything?

     

    I'll take any hints and pointers

     

    Thank U

Write an answer...
0/9000