Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Output data to Excel within/outside macro get different result

187
8 - Asteroid

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

 

 

4 REPLIES 4
Qiu
20 - Arcturus
20 - Arcturus

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

Can you upload a workflow if you can?

187
8 - Asteroid

@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
17 - Castor

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

Sapna Gupta
187
8 - Asteroid

Hi @grazitti_sapna 

 

I have uploaded the workflow

Labels