How to implement For each clause

Hello everyone. Please I need your help on this.

I have this 6 columns input and I want to create the column "auto-liquidation" that has a yes if Flag TVA = yes and ACHAT/VENTE = "Achat" and for each BELNR if there are two HKONT lignes "4456" and "4457" and 4456=-4457 then it's a yes else it's a no.

My issue is that I don't know how to implement the for each BELNR clause.

Can you please help me with this. It's urgent.

Thank you in advance.

image.png

Macros

Interface Tools

Accepted answers

binu_acs

@wsidihida Attaching the workflow and the macro, the below post mentioned by @apathetichell will help you how to downgrade your workflow

https://community.alteryx.com/t5/Engine-Works/Making-Workflows-Apps-amp-Macros-Backwards-Compatible/ba-p/779546

AutoLiquidation_Macro.yxmc

AutoLiquidation_190523.yxmd

All comments

wsidihida

binu_acs

@wsidihida Can you explain how you derived Yes and No for the first and second rows?

wsidihida

For the first row we have a yes because Flag TVA = yes and Achat/vente = yes and we have two HKONT one starts with 4456 and one starts with 4457 and Solde[4456]=-Solde[4457]

For the second row we have a No because Flag TVA = yes and Achat/vente = yes and we have two HKONT one starts with 4456 and one starts with 4457 but Solde[4456] != -Solde[4457]

Raj

can you share the Excel file.so i can help with the flow

Else you can first make the self join on Basis of Unique values to bring 4456 and 4457 in same row and simple formula tool will generate the desired result for you.

wsidihida

Here's the file.

I appreciate it.

Data.xlsx

binu_acs

@wsidihida One way of doing this

AutoLiquidation_190523.yxzp

wsidihida

Thank you so much for your help. But I can't open the file. I can only open yxmd extensions.

apathetichell

that error message shouldn't matter. just hit o.k and import it. If you still can't run it - there's a good guide on how to downgrade Alteryx workflow versions by @atcodedog05 floating around...

binu_acs

@wsidihida Attaching the workflow and the macro, the below post mentioned by @apathetichell will help you how to downgrade your workflow

https://community.alteryx.com/t5/Engine-Works/Making-Workflows-Apps-amp-Macros-Backwards-Compatible/ba-p/779546

AutoLiquidation_Macro.yxmc

AutoLiquidation_190523.yxmd

wsidihida

Thank you for your help I appreciate it!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703