Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

etrotter
Contributor II

Left Keep causing tables to split

Hello,

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:

Capture1.PNG

After: None of the split tables have any data in them.

Capture.PNG

5 Replies

Re: Left Keep causing tables to split

Are you doing a wild card load here to load multiple files?

etrotter
Contributor II

Re: Left Keep causing tables to split

Not a wildcard load, but there is a loop to load in multiple pages of the API

Re: Left Keep causing tables to split

Would you be able to share the script that you are using?

JustinDallas
Valued Contributor II

Re: Left Keep causing tables to split

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.

riccardozenere
Contributor III

Re: Left Keep causing tables to split

In addition to what Justin and Sunny said, check that you don't do a left keep inside the for loop.

Doing that would cause exactly the split you shown in the screenshot.

If this is the case, to resolve it I would use the left keep only at the end of the API calls.

Hope this helps,

Riccardo

Community Browser