Hi Experts, I want to find all the links that are connected to the address_ID I specified directly or indirectly (or any other nodeID, like email_ID, IP_ID etc.)  and return only application_ID. for example:   Application_ID   Email_ID  IP_ID Address_ID phone_ID 1                            email1    ip1       address1     phone1     2                            email2    ip2        address1    phone2 3                            email3   ip2         address2    phone5 4                            email5    ip1         address3     phone13 5                            email1  ip13       address13  phone13   if I specify parameter address_id=address1 then the program should able to return all 5 applications because   address1 is connected to ip1 and ip2 from application_id 1 and application_id 2 so both application should be returned in the final output    address1 is connected to ip1 which also  connected to application_id 4 so appliation_id 4 should be returned in the final output   address1 is connected to ip2 which is connected to application_id 3 so applicaiton_id 3 should be returned in the final output   address1 is connected to email1 which is conneted to application_id 5 so application_id 5 should be returned in the final output   I have used pro sql join to handle this problem but it seems to be inefficient as I need to specify number of time the iteration should run.   I want to achieve the outcome using hash table if possible!   I hope I made it clear.   Thanks ... View more

hi experts, I am quite new to scorecard. I am generating a scorecard model to predict fraud application using  scorecard node in EM. The result obtained from one input variable as following:   Variable Name:                   Group                scorecard point       weight of evidence             event rate (fraud)     delivery_date  1                         1                          24                         -1.82                                    52.75%                           0,  missing          2                          4                             0.06                                   14.56%                          2+                       3                          32                           -2.63                                   71.38%      coefficent 0.36 0.36 0.36   My understanding of the scorecard point indicates how likely the appliciation become fraud. The low scorecard indicate risky application. However this is not the case showed by the above example,delievery_date= 2+ is receiving very high scorecard(mean low risk) at the fraud rate of 71.38% and delievery_date=0 or missing has very low scorecard point of 4 ( high risk application) however only having 14.56% of its application become fraud.   If we have an application with delivery_date=0 then it will be given a total score=4 (assume delivery_date WOE is only input variable). Will that misclassify that application to high risk?     Thanks       ... View more

Hi Experts, I don't know if this is the appropriate thread to post this question. I am getting error to schdule DI Jobs when read external file like excel or csv. but I don't have issue execute DI jobs mannually   the errors message I am getting as following: ERROR: Unable to open file \\xxx\xx\xx. It does not  exist or it is        already opened exclusively by another user, or you need permission to view its data. ... View more

Hi Expert, I have a EG project only contain one single process flow. Within that single process flow, it has 171 tasks (like query builder etc.).   When I clicked Run project or Run proocess flow, I can see from left bottom corner, only 39 of them get submitted and executed whereas the rest has been ignored. I don't get any error or warning. Also I am getting message under title "Submitter", "This task "xxx" is already running" when I try to run some unruned job mannual after all 39 jobs completed.       The project was created in EG5.1 and now we are trying to migrate it into EG7.11.   I open the project (created in EG5.1) using EG7.11 (migration) directly.   The project is running fine in EG5.1.     THANKS! ... View more

Hi Experts, Is there any way to update the named range within excel using xlsx in EG? I have a client whose EG is running on linux server with no PCfile server installed. I want to export the data into a pre-defined Excel template without using proc export (you can't specify cell range) or ODS  as I need to load the data to the proper cell ranges (defined by named range). I need to maintain the excel format  while  update the data in the named range. Is it possible to achieve that? (Client does not have AMO) ... View more