Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Audit LOGS for BATCH Marco

VJ_88
7 - Meteor

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

1 REPLY 1
ChrisTX
16 - Nebula
16 - Nebula

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

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

 

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.

 

Labels
Top Solution Authors