Output data to Excel within/outside macro get different result

[187]

Hi Alteryx engineer,

I have weird observation 

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

			ABC	DEF
		A	1	5
		B	2	6
		C	3	7
		D	4	8

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

			ABC	DEF
		A
		B
			1	5
			2	6
		C	3	7
		D	4	8

I used union to generate this output dataset 

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

[Qiu]

@187 
It is weird. 
Is your macro a standard macro or batch macro?

Can you upload a workflow if you can?

[187]

@Qiu 

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

[grazitti_sapna]

@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]

Hi @grazitti_sapna 

I have uploaded the workflow