Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Render tool not working?

Vanessa_JWS
8 - Asteroid

Hi

 

I have a total of 4 sheets to output into a single file.

 

Formulas look OK and no errors have been noted.

 

However, it seems like only 3 sheets have been read. 

 

What is causing this issue?

 

Attached screenshot for reference.

 

Thanks,

22 REPLIES 22
ShankerV
17 - Castor

hi @Vanessa_JWS 

 

As per the screenshot attached, there is no issue with the Render tool.

 

The issue is with the Union tool output where only 3 tables are in output.

ShankerV_0-1671521181286.png

 

Hence the render tool also outputs only 3 sheets.

 

Many thanks

Shanker V

Vanessa_JWS
8 - Asteroid

@ShankerV  - Why is there only 3 outputs for the union tool? If I look at the "Output order", there are 4 sheets

ShankerV
17 - Castor

Hi @Vanessa_JWS 

 

Can you pleas share the screenshot with readable text under the Basic table and Formula tool where you have named the sheet name.

Will be helpful to deep dive the issue.

 

ShankerV_0-1671521930566.png

 

Vanessa_JWS
8 - Asteroid

Hi @ShankerV - I have attached the screenshots. Hope these are what you are looking for

Vanessa_JWS
8 - Asteroid

@ShankerV - I took a look again. Apparently there is not output for the "Basic table" in relation to the missing sheet. But I am not sure what is causing this?

 

Vanessa_JWS_0-1671523052199.png

 

ShankerV
17 - Castor

@Vanessa_JWS 

 

Delete the below Basic Table, and insert a new one from the palette. Do the linkage and then run.

Sometimes, this will help to overcome the issue.

 

ShankerV_0-1671524109016.png

 

If it works or not, let me know. 

 

Many thanks

Shanker V

Vanessa_JWS
8 - Asteroid

@ShankerV  - it is not working

ShankerV
17 - Castor

Hi @Vanessa_JWS 

 

Can you please attach the sample workflow, it will help to investigate.

 

 

Vanessa_JWS
8 - Asteroid

@ShankerV  - Attached is the workflow without data. Hope this helps. Thanks!

Labels