"Path" flow variable not recognised in CSV Writer

Hi,

I am trying to analyse data within a set of folders. For example:

===============================
image
I am looking to:

  • loop for each folder
    ** within the loop for a specific folder list the files for that folder, nested loop for each file
    ****process the data from the folder’s files
    ****NEXT file
    ** create an output CVS file that includes the data from all the folers files and name it “output.csv”
  • NEXT folder

Here is the routine I created

===================================

For some reason the CSV Write is not recognising the Path flow-variable I use - POINT 1 in the image below. CSV Reader does recognise the variable - POINT 2 in the Image.

Here is the CSV Writer

===========================

Here is the Path flow variable

===========================

Don’t understand what I am doing wrong.
Could you please help me?

Actually it does work. The workflow worked when fully running the outer nested loop.
Sorry!!!

2 Likes

Hard to tell from your post, but if you are using the same path then the file already exists when it gets to the second writer, then the writer node is set to “fail”. You can select append if that is the case.

Just noticed your new post. Glad it is working. Would have been too hard to diagnose without a sample of the workflow.

@iCornerstone sometimes you have to make sure when you set up the node that the flow variable is actually present in the preceding node. This has to have a green traffic light as having been fully executed. It is not sufficient to have the path flow variable present further up the line.

3 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.