Exclude from Summarize

Hello All,

I have a Dataset similar to the text Input file.

Where I want to exclude PROD ID P1 from the second summarize tool since P1 is already part of the first summarize.

Attached WF for reference

Workflow

Datasets

Developer

Output

Transformation

Data Investigation

Accepted answers

Hi,

Thanks I agree it does lack context but its hard to explain the scenario so I mocked up some data to get the desired result.

Thanks your solution works.

All comments

erickyaparevalo

Hi,

not sure the purpose of this flow and lacking of further context, I think you have to filter out values shown in first Summarize from values shown previously of the second one.

Attached the solution,

Hi,

Thanks I agree it does lack context but its hard to explain the scenario so I mocked up some data to get the desired result.

Thanks your solution works.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703