Hi All,
I have been struggling to achieve this output in many ways using render tool, but output doesn't come out well.
Please kindly assist me in achieving this, refer the attached workflow.
@Sarath27 Try this one
Sorry meant to attach the screenshot too
You can create a more or less endless loop and make hundreds of sheets this way if you wanted to. Block Until Done with Count Records/Append is my favorite way to deal with multiplesheet Excel outputs. The Count Records drops all other columns so there is no need to reconfigure anything with a select, just de-select the Count field in the Append Tool and the second data set will pass through uninterrupted.
Hi @Sarath27 . Please provide a packaged workflow (Options -> Export). This will include you data in the workflow. When Rendering data to different excel sheets, you need to change the Separator option to 'Insert Section Breaks Between Records' and pick the appropriate grouping field.
Ho @ChrisWaspe Pls find the attached package and help me out.
Any work around for this please?
@Sarath27 One way of doing this
@binu_acs I tried this already, but whenever I open this file its shows repaired and needs to be recovered and also column names are getting shrinked when expand.
Is there any work around with exporting raw data rather than using render tool?
Thanks,
Sarath.
@binu_acs Both the files have different columns, still union tool will work on this?
@Sarath27 yes, because we are giving the tab name separate it should work
@binu_acs Sorry to ask you again. I can see columns are mis-placed. Should we use block until done and if so where can I use it in the workflow?
@Sarath27 In this method you cannot use block until done because the Excel is splitting based on the tab names. Can you share a sample file with the issues and expected output?
@Sarath27 -- building off of @binu_acs previous workflow, do you mean something like this. This how I do it to avoid dealing with extra columns, etc. The CountRecords basically resets the data and you drop the count in the append tool so it's like it never happened.
@DanielG Thanks much for your solution. It worked well.
