Calling all Alteryx customers: Refer your colleague to try Alteryx and receive a $50 gift card. Sign up now!
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