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.
Solved! Go to Solution.
@wsidihida Can you explain how you derived Yes and No for the first and second rows?
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]
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.
Thank you so much for your help. But I can't open the file. I can only open yxmd extensions.
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...
@wsidihida Attaching the workflow and the macro, the below post mentioned by @apathetichell will help you how to downgrade your workflow