New reply on DataCleaner's online discussion forum
(https://datacleaner.org/forum):
Arjan replied to subject 'Urgent help'
-------------------
For describing how to do this I will assume you're using the Customers.csv
datastore which is delivered with DataCleaner.
To check if a "given_name" name starts with "A" or "B" and filter out all
negatives, you can best first create a regex. In the "More" menu select "String
patterns". This opens the "Reference data" panel. Here are three buttons you
can use to create a string pattern, click the one which creates a Regular
expression string pattern. Give the pattern a good name and for the String
pattern fill in {{{^[AB].*}}}.
Now close the panel and add a "Validate with string pattern" filter to the job.
In this filter select "given_name" as input column and for the String patterns
property, select the pattern which you just created.
Now add a "Convert to number" transformer to the job. By default a transformer
has no requirement. Set a requirement for this component. There are multiple
manners to do this. When you have the configuration panel of the component
open, You see a button containing the text "(No requirement)". Click this
button, select the "Validate with string pattern" option and for that select
"VALID". Now only the rows for which the "given_name" starts with "A" or "B"
will filter through.
In the "Convert to number" transformer you just added, select "income_amount"
as input. If you scroll down in the component, you'll see the component now
produces "income_amount (as number)" as output.
Now add a "Compare" filter to the job, for this filter, select "income_amount
(as number)" as input column, select operator "Less than" and compare value
"100000".
Now you can add a writer component to the job, e.g. a "Create CSV file"
component (or another writer, depending on your use case). For this component
select the requirement "income_amount (as number) < 100000" and set it to
"TRUE". Now select the columns to write to the CSV and select a file and you're
ready to go.
-------------------
View the topic online to reply - go to
https://datacleaner.org/topic/2408/Urgent-help
--
You received this message because you are subscribed to the Google Groups
"DataCleaner-notify" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/datacleaner-notify.
For more options, visit https://groups.google.com/d/optout.
