Duplication in Values

[#1]

Hi,

I have attached Table view. Application_detail_naps has channel field which includes e.g. branch, phone etc. Naps_Appl_Referral_Reasons table has Appl_Refer_Rsc_Cde field which incudes different rework reasons. Naps_Appl_Workflow_History table has Area which includes three options RCU, CU & RCMU. I need to show how many applications are submitted from each Channel against each Area and how many Appl_Refer_Rsc_Cde logged in each Area.

Application should go only to one Area from Channel but in some cases if applications goes to wrong area then Appl_Refer_Rsc_Cde is/are selected and then channel resubmitted to correct Area. Currently qlikview is showing Appl_Refer_Rsc_Cde under both areas (one is wrong area who selected Appl_Refer_Rsc_Cde and second correct area where resubmitted.) Appl_Refer_Rsc_Cde should be only shown under wrong area who selected it. e.g. application moved in RCU which is wrong area then RCU selects a Appl_Refer_Rsc_Cde channel under Application_Detail_naps resubmits to correct area e.g. RCMU. Currently Appl_Refer_Rsc_Cde is shown under both RCU and RCMU however it should be only under RCU not RCMU.

Regards,

Shoaib

[#2]

yes it's loading all tables other than t1 t2

[#3]

script as attached

[pokassov]

Why did you write prefix for tables like "DDEWV81B."?

[#5]

i have prefix with all tables but did not mentioned in the attached file. but this is not the issue. i am wondering the script i attached is correct or wrong

[pokassov]

Can you do this?:

1. Settings->Document Properties->General->Generate Logfile (set the checkbox)

2. Reload document

3. Find the logfile in the same folder with document and attach it here.

[#7]

Hi Cepren,

Thanks for your help. If you ignore the prefix then the rest of the script is the same as attached. I still could not sort it out

[pokassov]

Can you do this?:

1. Settings->Document Properties->General->Generate Logfile (set the checkbox)

2. Reload document

3. Find the logfile in the same folder with document and attach it here.

[#9]

as attached

[pokassov]

This is your original script without my advice. Put it together and reload again.

[#11]

it says left join and drop table not found