When using an import set, how to execute a variable using the file name as a key.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-29-2023 09:44 PM
I would like to sort files using business rules using file names as keys. Could you please advise .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-29-2023 10:19 PM
your question and the question content is different
what's your business requirement?
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-30-2023 12:02 AM
Thank you for your reply.
I use an import set to populate a table with data.
So, I am going to use business rules to specify the imported files and set unique actions.
For example, if the name of a file imported with an import set contains the characters Win, add the string to the target table. Is it possible to do something like this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-30-2023 12:34 AM
you can handle how data gets transferred to target table using field map and transform script (onBefore)
what did you start with and where are you stuck?
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-30-2023 12:29 AM
@Komazawa Akane
As per your above explanation, it seems like you want to evaluate the File Name and then run your transform maps to populate the data in your table.
This is possible using Scheduled Data Import.
You have an option in the Scheduled Data Import called as "Execute Pre-import Script" where you can check the attachment attached to the Data source and check the File name.
Please let me know if this response helps you in any way and mark it helpful.
Thanks