File Listener File data issue
Hi there,
I need an idea how to get/processed those data that was not included in the processing.
for example:
I have a file named Customer.csv with 2 data in it. this will be processed by the file listener
Customer.csv
name address
john new york#$^#%
vitalik canada
The result: only 1 data was processed (vitali). John was not processed due to invalid address.
Now, I want to get the data that was NOT processed and send to email or saved somewhere.
How do i get the data that was NOT processed.
Thanks.
Bits in Glass
IN
@BimboT50 In the processing activity, you can validate whether all the columns are in proper format. If having special chars, then you can store that data into another data table. So you can maintain a data table to maintain all the invalid data. Using that data in data table you can send email/do any action item. Once processing is done if data is not required you can delete those data from data table to reduce the data load due to further store.