Read between specific rows and output

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

Workflow

Accepted answers

afv2688

Would this do it?

Regards

sheet_number.yxmd

afv2688

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

sheet_number.yxmd

All comments

afv2688

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

afv2688

Would this do it?

Regards

sheet_number.yxmd

wdavis

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

NewFields.yxzp

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703