Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
Thx for ur time.. not getting desired result
2BVM-01
2BVM-02
2BVM-03
pls hlp
Need further clarification as i dont understand what is meant by not getting desired result...
What´s your desired result?
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
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
Hi,
Try this script
Data_Temp:
LOAD REGIONID, LOCATIONID
FROM data.txt;
LEFT JOIN(Data_Temp)
LOAD REGIONID, 1 AS Temp
INLINE [
REGIONID, LOCATION ID
2BVM-01, 111
2BVM-01, 222];
Data:
NoConcatenate
LOAD
REGIONID, LOCATIONID
RESIDENT Data_Temp
WHERE IsNull(Temp);
STORE Data into EXISITINGQVD.qvd;
DROP TABLE Data_Temp;
Regards,
Jagan.