In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

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
‎05-18-2023 02:55 AM

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.

 

Preview file
109 KB
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

10 REPLIES 10
wsidihida
6 - Meteoroid
‎05-22-2023 03:34 AM

Thank you for your help I appreciate it!

Reply
0 Likes
Fall Release Webinar
Alteryx One Admin Experience
Labels
Top Solution Authors
View All