Alteryx Designer Desktop Discussions

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

ACS Filter tool with 2 fields as combined filter

Andreas_____
5 - Atom

Hi all,

 

I try to fetch PO data from table EKPO, feeding in WERKS and MATNR; both marked as Selection;

 

However I get now multiple returns, as in this example:

 

Input 1: WERKS="DE55" MATNR"12345"

Input 2: WERKS="DE75" MATNR"67891"

 

Output 1: WERKS="DE55" MATNR"12345"

Output 2: WERKS="DE75" MATNR"12345"

Output 3: WERKS="DE95" MATNR"12345"

 

Looks like he's querying all provided materials in all provided plants, but I'd rather have him pull the unique combination.

 

Does anyone have a solution?

 

Thanks!

 

Br Andreas

3 REPLIES 3
Andreas_____
5 - Atom
 

2024-08-21_17-10-04.jpg

 

apathetichell
19 - Altair

Is this DVW? If so @darronwalton and team would be the ones to answer it.

darronwalton
8 - Asteroid

Thanks @apathetichell.

 

Hi @Andreas_____  - Please contact me directly or email the DVW Analytics team at acs_support@dvwsolutions.com. The team will be able to assist you.

 

Thanks,


Darron Walton

DVW Analytics

 

 

Labels
Top Solution Authors