Recursive LookUp

Tue, 15 Sep 2015 09:56:45 GMT

Hi Experts,

I have two files in with below sample data.

File 1:

UIDs

ABCD

EFGH

HIJK

JKLM

LMNO

OPQR

QRST

STUV

UVWX

WXYZ

File 2:

UIDREF1 ABCD	UIDREF2 LMNO
EFGH	WXYZ
HIJK	STUV
LMNO	WXYZ

I want to find for each record in File 1, recursive references in file 2. Meaning, for example, if I consider, ABCD from file 1, it is referenced in File 2, along with LMNO. Then LMNO is internally references WXYZ, and in turn WXYZ references EFGH. There the cycle stops. So the results is

ABCD -> LMNO -> WXYZ -> EFGH.

Similarly next record in file 1 is EFGH for which similar logic applied, result shall be

EFGH -> WXYZ -> LMNO -> ABCD.

Kindly Provide me with a script for achieving this.

Re: Recursive LookUp

jonas_rezende — Tue, 15 Sep 2015 19:45:10 GMT

Hi, vamsi kanduri.

When chosen UIDs = LMNO in File 1, what will be the result?

Re: Recursive LookUp

MarcoWedel — Tue, 15 Sep 2015 23:07:01 GMT

maybe you could use the hierarchy prefix in your load?

regards

Marco

topic Re: Recursive LookUp in QlikView

Recursive LookUp

Re: Recursive LookUp

Re: Recursive LookUp