Skip import set record when empty field available in file
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-25-2022 09:11 AM
Hi Team,
I want to skip the records while importing from data source if name field is empty and also need to skip records if name field have duplicate values?
Thanks,
Gan
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-25-2022 09:16 AM
Hi @Mohan22
For your first point you can below logic in onBefore transform script:
(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {
// Add your code here
if (source.u_name == "") //here replace with your name field
ignore = true;
})(source, map, log, target);
For avoid duplicate you can check the Coalesce field.
Hope it helps
Thanks,
Murthy
Murthy
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-25-2022 09:18 AM
Thanks for quick response.
we are not looking while transform. we are looking at importing the data into data source