Forum Discussion
Combining Columns in Different Tables
Hi RichardLinderma ,
Thank you saritasw and Ritaf1983 for the quick response!
Could you please confirm if the issue has been resolved on your end? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.
Thank you for your understanding and assistance.
Unfortunately, this still hasn't worked. true_origin[Origin_City_Name] and true_destination[Destination_City_Name] are apparently not the right types of parameters for the RELATED function, and it says it can't find Origin_City_Name and Destination_City_Name when using the function anyway.
RichardLinderma you mentioned -
invoice_details[b_location_hierarchy_origin] → true_origin[a_location_hierarchy]
invoice_details[c_location_hierarchy_destination] → true_destination[d_location_hierarchy]
These are many-to-one relationships, pointing from invoice_details (many) to true_origin and true_destination (one), which is ideal for RELATED() as long as the relationship is active and correctly set up.
If for some reason the relationships are broken or not recognized, try LOOKUPVALUE() instead. This function doesn't rely on an existing relationship.
Combined_Cities =
LOOKUPVALUE(
true_origin[Origin_City_Name],
true_origin[a_location_hierarchy],
invoice_details[b_location_hierarchy_origin]
)
& " / " &
LOOKUPVALUE(
true_destination[Destination_City_Name],
true_destination[d_location_hierarchy],
invoice_details[c_location_hierarchy_destination]
)This should work regardless of model issues, as long as your key values match exactly.
*****************************************************************************************************
If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!
Thank you,
Sarita