HI Team,
I have One table which has Vehicle ID and other Table which has PartDetails. I want to count claim number from this but both columns are coming from different tables. When I tried using this with DOMAIN TABLE it is giving me following error message:-
Pull-Up-function could not be executed. PU_COUNT_DISTINCT: Cannot execute PU-function on tables
[<DOMAIN_TABLE ( "O_CUSTOM_CLAIM"."VEHICLE_ID" , "O_CUSTOM_CLAIMLINEDETAILS"."PVTXT" )>] and ["o_custom_Claim"],
since they do not have a 1:N relationship. You might want to make use of the BIND function. Join path: [DOMAIN_TABLE
( "O_CUSTOM_CLAIM"."VEHICLE_ID" , "O_CUSTOM_CLAIMLINEDETAILS"."PVTXT" )]1 --> N[o_custom_ClaimLineDetails]N <-- 1
[o_custom_ClaimLines]N <-- 1[o_custom_Claim]. For more information on the join path, search for "Join functionality" in PQL documentation.
Can anyone assist?
Getting Error while trying use domain table function for two different tables
+4can you share your pql query as well ?
PU_COUNT_DISTINCT(DOMAIN_TABLE("o_custom_Claim"."Vehicle_ID", "o_custom_Claimlines"."PVTXT"),
"o_custom_Claim"."Clmno", "o_custom_Claim"."Vehicle_ID" IS NOT NULL)
This is the query I am using
Pull-Up-function could not be executed. PU_COUNT_DISTINCT: Cannot execute PU-function on tables
[<DOMAIN_TABLE ( "O_CUSTOM_CLAIM"."VEHICLE_ID" , "O_CUSTOM_CLAIMLINEDETAILS"."PVTXT" )>] and ["o_custom_Claim"],
since they do not have a 1:N relationship. You might want to make use of the BIND function. Join path: [DOMAIN_TABLE
( "O_CUSTOM_CLAIM"."VEHICLE_ID" , "O_CUSTOM_CLAIMLINEDETAILS"."PVTXT" )]1 --> N[o_custom_ClaimLineDetails]N <-- 1
[o_custom_ClaimLines]N <-- 1[o_custom_Claim]. For more information on the join path, search for "Join functionality" in PQL documentation.
This is the error i am getting
+4I think what you are looking for is a BIND and not domain table
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.