Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Render with blank columns

ArijitRoy
8 - Asteroid

Hi All,

 

I have attached an excel file. I want to render it but unable to do it.

 

I need Column A, B & C as blank and Row A1 and A2 also blank and then the data pasted as it is. Kindly check the below picture.

 

Is it possible? I need the output via Render tool only. 

 

I know I can apply formatting in excel and take the output but I have multiple sheets with similar kind of data that I want it on one single excel file and if I apply formatting on each sheet then the file size will be big that I don't want.

 

Render.png

2 REPLIES 2
messi007
15 - Aurora
15 - Aurora

@ArijitRoy,

 

You can start with an empty sheet like this :

 

Capture1.PNG

 

And then use the option below to update the empty sheet :

 

Capture2.PNG

 

Attached the workflow.

Please save the workflow and the output on the same folder or replace the output path.

Regards

ArijitRoy
8 - Asteroid

Hi @messi007

 

Thanks for your reply but I want the output via render. I have around 12 to 15 sheets like this that I want in one excel file. If I use formatting on the excel file then it will get heavy and also sometime it get corrupt.

 

Labels
Top Solution Authors