Doesn't support many to many linked record relationships?

[rbabayoff]

Hey,

It seems this data connector doesn't support many to many relationships. am I correct? It exports linked record fields with recid1, recid2, etc. and there is no way to match it against the record id in the linked record table.

If this is correct, is there a workaround?

Thanks

[marks]

Hi @rbabayoff - I believe you are correct. If you have a one-to-many relationship, you can use Tableau's relationship tool to join but with many-to-many, I too cannot find a way with Tableau to represent the list of record IDs (rec1,rec2,rec3) as an array. I also did not see a way in the Tableau WDC 2.0 SDK to code a column as an array.

If you think there's a way the WDC can be improved to support this (without manipulating the data/increasing the number of records on the user's behalf), please do let me know.

[stevenqzhang]

I think you should be able to split on the list of record IDs as a string (you may need to trip the leading and ending brackets). see https://www.rigordatasolutions.com/post/using-the-split-function-in-tableau