I'm relatively new to this Tableau thing. My company is using mySQL for our data source. The database has 3 tables.
LoanID ClientID Approved Verified Funded
LoanID DocumentType DocumentDate
The problem being that Table 2 and Table 3 are both one to many. Meaning LoanID 1 could have three documents and 4 denial reasons. I'd like to join all three of these tables but haven't found a way to do it where I don't duplicate approvals, verfieds and fundings.
Can anyone help? I can create some basic excel documents if you think that would help as well.
If you can create basic Excel sheets that mimic your data and build those into a packaged Tableau workbook, that would probably help the community to solve your issue. Packaged workbooks or data samples always help get a question answered faster (I learned that the hard way).