file reading macro does not read all data

[yuanlu]

My app with a file reading Macro only read data from the first file, even it show it picked up 2 file while executing. Can anyone please help me to find out what the problem is?

[yuanlu]

To add, I tried both executing it as analytical app or workflow, it did the same.

[binuacs]

@yuanlu Add a browse tool after the macro in your workflow and try running 

[binuacs]

@yuanlu Also I think you need to pass the sheet name along with the full path as the input to the macro .

[yuanlu]

Hi Binuacs, I cannot open your file. It says your app was created by a newer version Alteryx. 

[binuacs]

@yuanlu I just added a formual tool and updated the FullPath variable

[FullPath] + '|||templates'

[yuanlu]

it did not solve the problem, it still just red data from the first file

[binuacs]

@yuanlu Did you add the browse tool after the macro. I am getting the below record counts from both the files. If you are using the older version of Alteryx and to open the attached one , first open the attached workflow in a notepad ++ and change the version (will be in the top of the page) to your workflow version