HI,
Logs for normal Alteryx workflow are what we expect 700 rows read , 700 rows written
but for batch macro its not
I had to take picture hence quality might not be best.
For Batch macro it is like 4 iteration executed and then total records for all files but not individual file audit
Is there a way we have can a row inserted before 1st iteration is executed like 5 rows read then post iteration 5 records inserted ,
Iteration 2 11 records read 11 records inserted and so on
Example
If we have 100 files to be loaded
File 1 has 100 rows it stores or display 100 of 100 rows loaded
File 2 has 250 rows it stores or display 250 of 250 rows loaded
....
File 75 had 450 rows it failed mid way and so it should show loaded 225 rows and failed
A few suggestions:
ANALYTIC APPS AND MACROS TROUBLESHOOTING TIPS
DEBUG WORKFLOW
Apps and Macros have a debug feature that can be used to verify your app or macro is working as designed.
To use the debug feature, open the Interface Designer (Views > Interface Designer) and select the Test View (the Magic Wand icon on the left). Fill out the information requested by your app or macro, then click on Open Debug. A debug workflow will open as a new tab in your current Alteryx session. Run the debug workflow to make sure it is creating your desired results.
===============================================
also try: workflow configuration option (checkbox) for "Show All Macro Messages"
===============================================
Debugging Alteryx Analytic Apps
https://www.altertricks.com/how-to/debugging-alteryx-analytic-apps/
===============================================
These two options are helpful to debug macros:
1) Designer > View > Interface Designer > Test View (the magic wand icon on the left hand side) > input your values > Open Debug.
This will create a new standard workflow with the actual values coming from your inputs.
A copy of the workflow will open called Debug Workflow# (# being some number)
You can use the Debug mode to test what values are passed from the app interface to the workflow
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Random-results-while-renaming-fields/t...
2) Community > Blogs > Engine Works Blog > The X-Ray Browse: Macro Debugging Made Easier
Designed primarily for developing & debugging macros, the X-Ray Browse enables you to pick a location within a macro under development, to view the data passing through said macro at said location. The effect is similar to a Browse tool, but the data is made viewable through the encapsulating "skin" of the macro being developed.
https://community.alteryx.com/t5/Engine-Works-Blog/The-X-Ray-Browse-Macro-Debugging-Made-Easier/ba-p...
Gallery Download link for X-Ray Browse Macro: https://gallery.alteryx.com/#!app/X-Ray-Browse-Macro/546263f9398a7111307b0cdc
===============================================
Community > Blogs > Engine Works Blog > The X-Ray Browse: Macro Debugging Made Easier
Gallery Download link for X-Ray Browse Macro: https://gallery.alteryx.com/#!app/X-Ray-Browse-Macro/546263f9398a7111307b0cdc
X-Ray Browse Macro
Alteryx Studio - Alteryx Products
Author: Dan Jones
Designed primarily for developing & debugging macros, the X-Ray Browse enables you to pick a location within a macro under development, to view the data passing through said macro at said location. The effect is similar to a Browse tool, but the data is made viewable through the encapsulating "skin" of the macro being developed.