Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

vb_qv_11
New Contributor II

Assigning a parent-child mapping

Hi,

I have a pair of identifiers that are linked by an AGENTID:

AGENTID

ISSUERID

555

1234567

555

1234568

ISSUERID 1234567 is the "parent" and ISSUERID 1234568 is the "child". I want to create a new column in my table named PARENT_ISSUERID, and assign the value of 1234567 to the new field, for the "child" row - so, the result would look like this:

AGENTID

ISSUERID

PARENT_ISSUERID

555

1234567

-

555

1234568

1234567

How can I achieve this result in a load script?

I have thousands of pairings like this, so the "parent" and "child" ISSUERID values cannot be hard-coded - I am just using 1234567 and 1234568 as examples.

Many thanks,

VB

1 Reply
Not applicable

Re: Assigning a parent-child mapping

so You've got the pairings on a separate table right?

You could use left join function... i guess

Community Browser