Hey, may I ask if someone may know how to match for following scenario please? Basically, company A has 200 receivable from company B. Company B need to pay 200 to Company A. Account categoryAccountIntercompanyCompany ACompany BAccount receivable1000Company A 00Account receivable1000Company B 2000Account payable2001Company A0-100Account payable2002Company B00Account payable2001Company A 0-100Account payable2002Company B00 I would like Alteryx to give me a summarise table like following Company A & BNote (No need to include in Alteryx)Current asset mismatch0200-100-100 Thanks a lot!

Match intercompany transactions

Hey, may I ask if someone may know how to match for following scenario please?

Basically, company A has 200 receivable from company B. Company B need to pay 200 to Company A.

Account category	Account	Intercompany	Company A	Company B
Account receivable	1000	Company A	0	0
Account receivable	1000	Company B	200	0
Account payable	2001	Company A	0	-100
Account payable	2002	Company B	0	0
Account payable	2001	Company A	0	-100
Account payable	2002	Company B	0	0

I would like Alteryx to give me a summarise table like following

	Company A & B	Note (No need to include in Alteryx)
Current asset mismatch	0	200-100-100

Thanks a lot!

Workflow

Accepted answers

abacon

@johnny_jy Just summarize the 2 dollar value columns, use a formula to compare and create your identifying text column, then remove the columns you don't need.

Bacon

Match_InterCompany_Transactions.yxmd

RWvanLeeuwen

Hi there,

I built upon the prior suggestion of @abacon and I feel it might be appropriate to look at how I pivoted the data for this use case.

Have a look at attached file, and the image here

alternative approach intercompany data.png

Match_InterCompany_Transactions - RWvL.yxmd

All comments

abacon

@johnny_jy Just summarize the 2 dollar value columns, use a formula to compare and create your identifying text column, then remove the columns you don't need.