Output data to Excel within/outside macro get different result

Question

Hi Alteryx engineer,

I have weird observation

I have a macro output dataset like below to excel sheet range and it is as expected

ABCDEF    A15    B26                  C37    D48

but when I try to call this macro from my yxmd main workflow, i got below result , any advice?

ABCDEF    A      B       15     26    C37    D48

I used union to generate this output dataset

Dataset A&B  union  two empty rows and union Dataset C&D

187 · Answer

Hi @grazitti_sapna

I have uploaded the workflow

grazitti_sapna · Answer

@187 , Its difficult to give advice without the workflow. Please share the workflow package with workflow and macro so that I can debug and check the issue.

187 · Answer

@Qiu

Hi Qiu  it is standard macro, I attached the workflow and the data is cleared, but you can see what exactly happened

test.yxzp