Fusion Accounting Hub mapping sets not able to be used in formulas

Summary:

We need to perform an advanced lookup based on two mapping sets, where the resulted values from the first mapping set are used to initiate logic on the second mapping set.

Content (please ensure you mask any confidential information):

not able to provide content this is a systematic limitation question

Version (include the version you are using, if applicable):

on most recent release of Fusion Accounting Hub

Code Snippet (add any code snippets that support your topic, if applicable):

--  Example SQL call to the function

select m63.fee_code, m63.consumer_indicator,

       m63.investor_id, m63.inv_category_code,