Thank you for your response. Sharing with you some more info and screenshots.
First, here's the connector from GDS:
And here are some info about my case.. I have a form with a number of child tables. But for the purpose of illustrating my issue, I will use only 3 tables from my form. My form has 3 levels => (1) Structures, (2) Households, (3) Members
In the image above, you will see that i made separate connections and did not use the Blend Data option. I will explain why later.
My parent table, Submissions, contain information about the structures. And to each structure, one or more households may be related or associated. And to each household, one or more members may be related. The household is a repeat under the structure (Submissions) and the member table is repeat under household. When I connect to the the Submissions table, here's what I get:
No problem. Correct number or count of rows/submissions or structures. But when I view the fields, here's what I get:
677 is actually the number of fields in the entire form, including the child tables. Btw, my form has about 30 child tables. And I have no problem processing and visualizing them in Qlik Sense. Going back, it seems that the parent table or data source is referencing a flat table. But it doesn't include the data. All fields of the form but data from the Submissions/parent table only. And when I create a report based on that first table, with Count and Count Distinct, here's what I get. The second column is actually a field in the Members table. I just tried to check if the table will return some values. But it did not. So maybe the table did not import the data from the child tables, only the fields. I made the wrong assumption in my first post. I thought the connection to the Submissions table also included the data from the child tables.
The first column is a field/dimension in the Submissions table and the second column is a field in the members child table. I am not sure what is being calculated in the last column when I tried to use the Count Distinct aggregation.
Moving on to the second table, the household table:
Again, the count of rows seem correct. And again, this is a repeat under Submissions.
However, it only returns one field which is the Submissions ID for the repeat. It doesn't have the PARENT_KEY that can be used to link it to the parent table. Just this single field. While all the other fields are in the first data source.
And when I try to create a report based on this table, this is what I get:
The same goes with my Members table. The data source gives the correct count during configuration. But when I create a report, it returns 0. Also with only one dimension. Only the Submission ID field in the Members child table.
I hope I was able to explain the issue clearly. If you need more information, kindly let me know.
Thanks and cheers,