Hi,
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?
ID | NAME | DATE | STATUS | ||
1 | ABC | 20200116 | Approved | ||
ID | ISSUE | AVG | YLD_TO_MAT | MATURITY | |
2 | 113 | 60.3 | -0.27 | 9.88 | |
ID | INTERVAL | RATING | PCT | ||
3 | 1-10YR | Aaa | 60 | ||
ID | RATE | SECTOR | VALUE | CREDIT | |
ID | QUAN | WEIGHT | PCT_OF_PORT | IDENTIFIER | ISIN |
5 | 545 | 6.2 | 29% | US9382407 | LA093284 |
Solved! 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
Hi @AnandKumar1
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!
Thanks
Will
Hello @AnandKumar1 ,
Here you got them.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regards
@afv2688 Everything is fine but i'm getting my output like this.
SheetNumber | RecordID | 1 | 2 | 3 | |
1 | 0 | ID | NAME | DATE | STATUS |
1 | 1 | 1 | ABC | 20200116 | APPROVED |
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?
ID | NAME | DATE | STATUS |
1 | ABC | 20200116 | APPROVED |
Hello @AnandKumar1,
This should do it now. Output I get now:
🙂
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regards