It seems your SharePoint List datasource is not well structured and will need to be pivoted. Once this is done, you can then join DS Data to Pivoted SharePoint List. I added both data sources into same Excel workbook. Then pivoted and joined the tables in Tableau. See attached workbook.
Rename Pivot Field Names and Pivot Field Values if required and then join the data
Hope this helps.
I can’t join using SharePoint lists, so this won’t work.
HARMELIN MEDIA | SR. SYSTEMS ADMINISTRATOR
t: 484.270.9541 c: 215.738.1489
I understand if you can't join the data. However, the options for this case are very limited because the data is not well structured.
If I may ask, why is it not possible to join using the SharePoint List?