Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to implement For each clause

wsidihida
6 - Meteoroid

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.

 

10 REPLIES 10
wsidihida
6 - Meteoroid

Thank you for your help I appreciate it!

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels