topic Related Party Match Off in Alteryx Designer Desktop Discussions

Related Party Match Off

nora_m — Tue, 14 Sep 2021 01:51:56 GMT

Hi,

I am trying to convert the interco data to USD so i can create the match off and netting process. i am having issues with the conversion. can you please help me?

also, can you please help me with how to create the match off process?

Re: Related Party Match Off

Ar13f — Tue, 14 Sep 2021 03:40:08 GMT

Dear @nora_m

what do you mean by the result as below?

if yes, I use the data from you, I just changed a little from the formula you made. I deleted the formula that was colored yellow

please see the attachment I provided. hope this helps you

Re: Related Party Match Off

RolandSchubert — Tue, 14 Sep 2021 05:29:17 GMT

Hi @nora_m ,

if I got you right, you want to convert all InterCo data to USD and perform the intercompany matching process by group currency.

Thus, you only need conversion to USD, you can use a Filter tool to select only these rows (TO = USD).

Join can be Entity Currency = From (as To is always USD).

For the matching, I created an additional column for the expected account name to match (e.g. Income Interest , match with Interest Expense)

Using a Join tool to match by Entity/Partner Entity and Account/expected Partner Account should give the data you need.

Let me know if it works for you.

Best,

Roland