Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
Check attached solution,
let me know if it works for you
I used the below option
Hi @Chelseaa
Here is how you do it.
Workflow:
Step1 : make sure you assign group by like below.
Step2 : Configure like highlighted below with section as the groups.
This was you can get multiple sheets and also specify sheet names.
Hope this helps 🙂 Feel to ask if you have any questions
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
Hi @Chelseaa,
I'd use a slightly different technique to @Assaf_m and use the layout tool to define "Section Names" (in other words sheet name) in the Layout tool which will allow you to render with the external projects and internal projects sheet names you wanted.
If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.
EDIT: Same method as @atcodedog05
Regards,
Jonathan
@Assaf_m @atcodedog05 @Jonathan-Sherman
Hi all, thanks for your help! i have tried your methods but i am facing 2 issues.
1. I have a warning from the Render tool: "The current page layout will cause some data to be incorrectly truncated. you may consider modifying how the data is laid out"
And when i open the excel file, i get this prompt as well:
if i click "yes",
And my excel sheet does not look normal at all (the column names are all being cut off. for reference, column A = 'segment' and column B = 'function'):
2. the file being generated only create 1 tab, although my grouping has 2 types of grouping.
Would appreciate if i can get some advice on this, thank you!
Hi @Chelseaa,
This will be caused because of the "size" you're rendering too (in this case the width of the table), you'll want to take a look at the bottom of the configuration pane of the render tool.
If you change your Paper Size to "Custom" and increase the first number (8.5) this should solve your issue, i'd go about increasing it in units of 10 and depending on whether the width of the table is going to be increasing from the size it is currently then perhaps also give it a bit of a further buffer!
If this solves your issue please mark the answer as correct, if not let me know!
Kind regards,
Jonathan
With regards to the second point could you check the layout tool to ensure you're specifying the "sheet name" field?
And also check you're using the [Layout] field in the render tool with section breaks?
If this solves your issue please mark the answer as correct, if not let me know! Might be easier to diagnose if you're able to attach your current workflow? (even if it uses dummy data)
Regards,
Jonathan
That works, thank you!
Sorry, another question, how to i change the alignment for certain columns?
eg. for numerical data (jan20, feb20, mar20 columns), i would like the alignment to be to the right, but for text data (Location city / work country), alignment to the left
if it is not possible to customise the alignment for certain columns only, how do i make everything aligned to the left? my current settings is already left:
or am i looking at the wrong setting?
Thank you!!
Hi @Chelseaa,
You can change the alignment for certain columns in the Table tool:
Select the field to change the alignment for and you'll find the dropdown on the right hand side "Alignment H", just change that to left.
If you're wanting to change the alignment of any new columns that may come in the future then you can go through the exact same process with the "Dynamic or Unknown Field" placeholder
If this solves your issue please mark the answer as correct, if not let me know!
Regards,
Jonathan
