Why Macro output is different between running inside and outside the Macro workflow?

goosekong

Hi all,

I got a weird situation when I run the macro workflow inside, the first row of field F of the output is 0. However when I run the macro in an analytical app, the first row of field F of the output is not 0. All the output moves up by one row. Both the data sources between the inside macro workflow and outside macro workflow are the same files. Why it happens?

Run inside the macro workflow:

Run outside the macro workflow:

davidskaife

Can only summerise that something is different with the data/inputs when inside the Macro, compared to when you run it as an App. Tricky to troubleshoot without seeing the workflow.

Are you able to remove the sensitive data/mock something up at all?