Are you using any mapped drive letters in paths for inputs or outputs? Is there any info in the Outputlog?
Hello
I am using a structure to create dynamic input and output path, \03. JSONS\yyyymm\31. Compliance\UAT\giftsAndEntertainment.Quarterlytrend.yyyymm.Json. and the yyyymm will be replaced by the parameter to pass through in.
in the outputlog, there is no message about where the output been write to. However, if i run it in the designer, i can see there is type of message called "Files" which it show where the output been write to.
Thanks
Chunbin
Can you post a screenshot of the Output Data tool configuration and the output path from the workflow results when you run it manually.
Hi
i have attached 2 screenshot as i did test for output.
the first one: output successes is where i manually type the output path in a text tool then connect with output data tool directly. then it produced output correctly.
Second one: output failed is where the output generated dynamically by using formula tool, and output the result by using output data tool. and this is the one that failed and want to fix.
Thanks
The way I would test this is to build the formula 1 step at a time, so start with just putting the static path and filename in your formula tool, like this:
Then change it to use the dynamic [yyyyMM] field and test again
Once this is working correctly, change your formula to an if statement and test again.
It could be something like the folder [yyyyMM] does not exist or is not in the format you expect, or the if statement is not behaving like you're expecting.
HI @DavidP
As you have suggested, i have tried both method and they are not working at all.
Therefore i have tried to add an extra output tool from beginning of reading the file till the output. Surprisingly, none of the part of process has contains any data.
any idea?
Thanks
CHunbin
Can you share a version of the workflow for me to look at?