Start Free Trial

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

5 REPLIES 5
Andreas_____
5 - Atom
 

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

apathetichell
20 - Arcturus

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

 

 

deepaprashant
5 - Atom

Would have been great Darren if the answer was posted here to help the community!

hassanmurad
5 - Atom

I have sent an email but it wouldve been nice if the response was here for everyone to refer to.

Labels
Top Solution Authors