I have parent PBS and Child PBS, how do I identify which are repeated multiple times?
I think that you may need to leverage a multi row formula from the way you have presented your problem. Can you take a look at the attached workflow and see if this helps? Just point the input file at the sample data on your desktop that you sent over.
Hi @jakaur32
It is a bit tough to know what your data looks like without a sample, but maybe take a look at the Unique tool in the Preparation tool category. This has two outputs, one with unique values, and one with all of the duplicates.
As for the Parent and Child values, can you give context as to how this data is structured? Maybe provide a sample or screenshot.
I hope this helps!
So, I have attached a sample file from which I have to extract the usages that are highlighted in yellow.. all the level zeros which are preceded by 1 or whatever number. in excel I used to insert an extra column between my data. and I would use the following formula: =ifa2>a3, true, false. and then I would just filter in on all the true values. I have not had any luck in alteryx so far. Thank you.
