Hi
I have 3 sheets which I would like to combine into a single excel file (output) in separate tabs (i.e. a total of 3 tabs).
However, I noted that the details for the 3 sheets are all combined into a single sheet when I generated the output.
Can I ask what is causing this issue?
Attached are some screenshots for reference.
Thanks
Vanessa
Solved! Go to Solution.
Hi @Vanessa_JWS
I noticed that you have not selected the Check box in Group By as "Sheet".
I have gone through the remaining settings too and others seems quite good.
Could you please try selecting the Check Box with Sheet and run to get the desired output.
Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.
If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!
Many thanks
Shanker V
Hi @Vanessa_JWS
Before selecting the Check box for Sheet, I would also recommend to create the sheet names for 3 different sheets which you need to output.
This will help to overcome the issue.
Create the sheet name for all 3 sheets after the Basic table tool you have used in your workflow.
Layout tool configuration:
Render tool configuration:
Output:
Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.
If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!
Many thanks
Shanker V
Hi @Vanessa_JWS
If I understand your requirement, you want to remove the color of heading and alternate rows with light grey color right?
Many thanks
Shanker V
Hi @shanker - Yes that's right :)
Hi @Vanessa_JWS
Please follow the below steps:
Click the Basic Table
In the Configuration Pane select the Default Table Settings
You need to modify the below highlighted to White.
Click the ... button
Click on the Yellow highlighted in Custom colors and Select ok.
Here is the desired output for you.
Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.
If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!
Many thanks
Shanker V
Hi @Vanessa_JWS
Post the above changes, it will also inherit in the final Render tool also.
But, if you need this to have inherited in all sheets, you need to change the settings in all 3 Basic Table tool used in your workflow.
Many thanks
Shanker V
Thanks @ShankerV ! Appreciate your help!