update db record directory name

Jeroen Louwerse

• March 28, 2017 13:48

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?

0

• Official comment

  

  David Paras

  • April 03, 2017 17:02
  • Edited

  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

   

   
• 

  Jeroen Louwerse

  • April 04, 2017 14:03

  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
• 

  David Paras

  • April 06, 2017 21:35

  Try using the substring function to isolate the part of the file path that you need

  0
• 

  Jeroen Louwerse

  • April 07, 2017 11:33

  Great! Thxs David.

  0

Please sign in to leave a comment.