Additional RECORDS Dropped on RIGHT JOIN - PLEASE HELP!!

[#1]

Guys, please help me fix this issue..

Requirement: I am checking for particular region ids in the existing QVD. If it exists then i am dropping the MATCHING set of REGION ID's from the existing QVD and writing the REMAINING/REGION Id's Records to the EXISITING QVD AGAIN

Below are the steps followed :

1)      Read the DELTA FILE input data

2)      RESIDENT Load the the contents of the input DELTA file to TEMP table (Qlikview) and sort by REGION ID

3)      RIGHT JOIN the above TEMP table with EXISTING QVD data (read from destination folder) USING THE KEY REGION_ID and remove the REGION IDs from EXISTING QVD for the region ids that are already existing in TEMP TABLE.

4)      Resultant TMP TABLE contains the REGIONID with single LOCATION ID's and the Remaining NBN LOCATION id mapped to the REGION ID's are getting DROPPED. I DO NOT want the
other LOCATION id's to drop.

ie,  If there are multiple instances of LOCATION id mapped to REGION ID, only one instance of a REGION ID and LOCATION ID is captured. I need other instances of LOCATION ID mapped to REGION's also to be captured.

I am facing issue on step 4. I have provided the actual / expected result below. I have actually coded the scrip based on the above steps but it is not working. PLEASE PROVIDE ME THE QV Script.

Provided the INPUT DELTA FILE CONTENT and EXISTING QVD CONTENT. (as to how it appears)

(Note: REGION ID is NOT UNIQUE but LOCATION ID is UNIQUE)

DELTA FILE CONTENT:

REGIONID LOCATION ID     

2BVM-01  111
2BVM-01  222

EXISTING QVD:

REGIONID LOCATION ID

2BVM-01      111
2BVM-01       222
2BVM-01       888
2BVM-01       999
2BVM-02       777
2BVM-02       666
2BVM-03       555
2BVM-03       444

ACTUAL RESULT

2BVM-02  777
2BVM-03  555

EXPECTED RESULT

REGIONID LOCATION ID

2BVM-02       777
2BVM-02       666
2BVM-03       555
2BVM-03       444

If i am using LOCATION ID as a KEY for RIGHT JOIN below is the result

2BVM-01  888

2BVM-01  999

2BVM-02  777

2BVM-02  666

2BVM-03  555

2BVM-03  444

[jagan]

Hi,

Is it working?

Regards,

Jagan.

[#3]

Server down, couldnt login. I will let you know soon. Thx

[#4]

Your are Awesome!! Thanks buddy!!

Pls help me if i need any assistance in future    would be helpful if you could share your email id as well??

MANY THANKS!!