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]

Hi @goosekong 

Are you able to share the Macro/Workflow and data at all? You can export the Workflow as a package, which will then include the data input (if it's Excel/CSV etc) plus the Macro's

[goosekong]

Sorry the data include some business information which I can't share online. Do you have any clue about this situation?

[davidskaife · Accepted solution]

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?

[goosekong]

Thanks. The problem was solved, which was caused by different input data.