split data based on accounting system

[rojan]

Hi,

I want to make a work flow bases on below data

Grup	acc	amount	ststem
499111	301111	140325.1	CUS
499111	501112	140325.1	WIN
499411	501411	7409.26	CUS
499411	501407	7409.26	WIN
499411	501411	7409.26	CUS
499411	501407	7409.26	WIN
499899	301899	13.69	CUS
499899	501999	13.69	WIN
499958	301958	264483.5	CUS
499958	301958	264483.5	CUS
499958	301970	264483.5	WIN
499958	301970	264483.5	WIN

Below are the conditions

1) account number corresponding to Win should come first and corresponding CUS account to come second 

and corresponding amount

eg 

account1	account2	amount
501112	301111	140325.1
501411	501407	7409.26

since amount of both system are same i want one column for amount

Above example i have total 12 entries so i want to make 6 raw 

2) goup account of Win & cus should match

[echuong1]

If I understand your requirements correctly, this is what you're looking for?

[grazitti_sapna]

Hi @rojan , try this.

[RolandSchubert · Accepted solution]

Hi @rojan ,

what about splitting by source and joining by amount? Added an additional identifier to handle duplicate amounts.

I've attached a smple workflow. Let me know if it works for you.

Best,

Roland

[rojan]

Hi

Thank you so much. It will work out.

Regards

rojan