I have a lot of XML filees with random name. In each file is field ‘DOC’. It can has value = ‘scheme1’, ‘scheme2’ or ‘scheme3’.
I make 3 different data mapper for each scheme.
I need to capture file (mask: *.xml) and Check condition if ‘DOC’ == ‘scheme1’ etc.
It is possible to check record ‘DOC’ after execute data mapping? How can i read this value in workflow?
Of course…in Workflow, you simply set-up a text condition using the plug-in “Text Condition”. The you right-click in the field “String” and you select “Get Data Location”. The rest is self explanatory. The result will be a branch that goes right when true and keep going straight when false.
Hope that helps.
It is possible to open up an XML file within the workflow and read a node value into a variable.
First you’ll want to create a Branch and do a Folder Capture to open the XML file.
Next, define your variable name by creating either a local or global variable as needed.
Finally, you’ll need to use Set Job Infos and Variables. Select the variable you created previously and in the Value you’ll right click and use Get Data Location to select the ‘DOC’ node in your XML. Now you’ve got the value in a variable that can be used elsewhere in the workflow.
However, one problem I can forsee will be this: How are you determining what XML file to load? Is there a value in your datamapper that tells you which one? You say they have random names above… so it’s the link between the two that might be tricky.