update db record directory name
I have created a variable (varDirectoryName) that has a directory name in it. Like d:\test1, d:\test2 or d:\test3. When varDirectoryName is d:\test1 a database record named CODE must be updated to 0123,
when varDirectoryName is d:\test2 a database record named CODE must be updated to 4567 or when varDirectoryName is d:\test3 a database record named CODE must be updated to 8910.
How can I create this in a Data Mapper?
You can use the get-context function within the data mapper to check the value of the varDirectoryName variable. Then depending on the directory name, map the needed value to the CODE field of the output schema
Thank you! It's working.....the directory name is an unc path someting like this: \\10.100.100.100\appdata\ESB\test\DVN. Is it possible to use only the part DVN and not the complete unc path?0
Try using the substring function to isolate the part of the file path that you need0
Great! Thxs David.0
Please sign in to leave a comment.