I am experiencing a weird data issue. I created a model using left keeps and everything was working, but I edited the API call, but the tables should have been uneffected, but now all my left keeps cause my tables to split. What causes a left keep to split, and how do I correct this issue?
Before the left join:
After: None of the split tables have any data in them.
Was your API call set to page before you made the change? I see that the tables have similar data structure and have such a large synth key shared betwixt them. Is there a field that ISN'T part of the synth key? I'd like to know if a field is possibly keeping the automatic Concatenate function from kicking in.