Hi there,
I have Incident_no in the csv which I don't want to include into the calculation. Data is coming from the database. Is there any way that I exclude the records that contain incident number present in CSV? I tried with Feature joiner but it didn't give an option of not equal.
Best answer by takashi
I think the FeatureJointer can be used. Just use the records output from the UnjoinedLeft port, after joining the CSV features (entered into the Right port) to the DB records (entered into the Left port) using incident number as key.
Other than the FeatureJoiner, the DatabaseJoiner or the FeautreMerger could also be available.
Which option did you choose to configure the CSV writer feature type - automatic, manual, or dynamic?
Which option did you choose to configure the CSV writer feature type - automatic, manual, or dynamic?
I used CSV reader to read the incident_no from the file. I am not using CSV writer feature
It seems that I misunderstood the situation.
You are reading records from a database.
You have a CSV table which contains incident numbers, and you need to remove DB records whose incident number matches one of them read from the CSV.
Right?
It seems that I misunderstood the situation.
You are reading records from a database.
You have a CSV table which contains incident numbers, and you need to remove DB records whose incident number matches one of them read from the CSV.
Right?
Yes, You are right.
I think the FeatureJointer can be used. Just use the records output from the UnjoinedLeft port, after joining the CSV features (entered into the Right port) to the DB records (entered into the Left port) using incident number as key.
Other than the FeatureJoiner, the DatabaseJoiner or the FeautreMerger could also be available.
