Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a series of flat files, of which 2 are particularly troublesome... The Parent table has 99% of the data I want, but some of the rows have child data in Child (ColD).
The record in Child joins to ColC
Would this work in theory:-
Load [ChildA] as [ColC], [ChildB]
Load [ColA], [ColB], [ColC]
Resident Load [ColA],[ColB], [ColC]
Resident Load [ColD] from Child;
(I should add that I'm away from my server for the weekend, and this is seriously bugging me!)
Not 100% sure what you are trying to do, but your resident is wrong to begin with.
Loading data from a previously loaded table ‒ Qlik Sense
But I think a resident is not needed at as you seem to be taking unneeded steps.
In your example it is unclear where field D is located. I am going to assume in the "Child" table.
I am also having some doubt about what the key field is between the two tables. I am guessing field C since you are renaming something to C
If so, this is what I think the script should look like:
Load [ChildA] as [ColC], [ChildB], D
The end result will be a table called "Parent" with these fields:
If this does not answer it for you, please be more clear about which table contains which fields and what should be the end result.
maybe this helps:
Hierarchy ‒ QlikView