Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
yes it's loading all tables other than t1 t2
script as attached
Why did you write prefix for tables like "DDEWV81B."?
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
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.
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
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.
as attached
This is your original script without my advice. Put it together and reload again.
it says left join and drop table not found