Hello,
I need to use a formula to filter out several items and then for those that are false to come out in an output
thanks
two ways - either you check each value against the proper value which is type specific (ie for your number row it's is number=x, and for your string row it's is string="y"...
how i'd do it:
or you lose all the field types and you transpose with your record id as a group identifier. Then you check each column (now in value) as if it was string.
use a filter tool to filter out record ids where you have "false"
now you have the record ids - but not the full data set. You get the datasset back and the proper formatting by using a join with the pre-transform dataset with record id as the identifier.
summarize - group by record id. count distinct whatever column you are looking for duplicates in... duplicates will have two values or more.
nested in this case refers to two functions on the same field. so first convert it to string tostring() then get length on the string with len. so len(tostring())...
Hi @VeronicaElse
Some sample data might be helpful here to get you to the right option. Two thoughts:
You can create a new Boolean variable in the formula and then assign it "False" based upon the conditions being met. Then you use a filter as described by @Luke_C and connect and output data tool to your False anchor...
I am not sure how to provide sample data since it is confidential.
I need to have filter/formula for MDO Name= GBG, Program= 01 or 02, Plan Code= 1G or 2D, MEthod received= V or W, Received by= 1
and so forth then these columns that do not have these specific things listed to come as false statement? And can this come out as an output as well, is this possible?
ANY HELP IS GREATLY APPRECIATED.
🙂
So, use the Boolean Variable for all the columns I listed and assign it to False? So this would all be in one column formula?
Sorry I am new to this field 😕
