Read between specific rows and output

[AnandKumar1]

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

[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 · Accepted solution]

Would this do it?

Regards

[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

[AnandKumar1]

@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?

[afv2688]

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

[AnandKumar1]

@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

[afv2688 · Accepted solution]

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