This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I've got an output something like below but i want to make separate table for each ID.
Means ID=1 will be stored in a single output file then ID=2,3,4,5 and so on. There could be multiple file or multiple tab is single excel output
But some ID is blank and there will be no data for that. But still we have to save it separately.
The next ID will have a incremental ID number i.e if after ID=3 is blank data then next ID will be 5 not 4.
Is it possible to achieve?
Go to Solution.
Go to Solution.
Hello @AnandKumar1 ,
On the output tool you will see on the bottom part a checkbox with 'Take File/Table Name From Field
Select the box and select your ID column. This would do it
Edit: This wont work if your data is not present
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Regards
Would this do it?
I have continued on from what @afv2688 has built for you and turned this into a Macro so that you can have each separate output file with the specific headings contained within your original dataset.
However, if you do not require this, then @afv2688 solution will be a much more simple way to implement!
@afv2688 I did checked that box but dint think of using SheetNumber Multi-row logic. Thanks for your help.
@wdavis I'm not able to import the zipped file. Can you drop a yxmd file?
Here you got them.
@afv2688 Everything is fine but i'm getting my output like this.
In all the output tab, there is a row with Sheetnumber,RecordID,1,2,3 and so on which i dont want.
Is it possible to remove that and get a proper output format like below?
This should do it now. Output I get now: