Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

arjanijlenhave
New Contributor II

Mother daughter

Hi all,
The following table i have made:
MotherDaughter
12
13
14
15
My result must be (mother en daughter must be the same in the same table)
MotherDaugther
12
13
14
15
11
But how?
Best regards,
Arjan
1 Solution

Accepted Solutions
Not applicable

Re: Mother daughter

Would it help:

[prime table]:

LOAD Mother,

          Daugter

Resident [some table];

concatenate (prime table)

LOAD Distinct Mother,

          Mother as Daughter

Resident [prime table]

2 Replies
Not applicable

Re: Mother daughter

Would it help:

[prime table]:

LOAD Mother,

          Daugter

Resident [some table];

concatenate (prime table)

LOAD Distinct Mother,

          Mother as Daughter

Resident [prime table]

arjanijlenhave
New Contributor II

Re: Mother daughter

Thanks!!!

Regards,

Arjan