topic Re: Advanced data extraction in AutoCAD Forum

Advanced data extraction

W_DE_HOON — Sun, 29 Nov 2020 18:37:34 GMT

I have made a number of different blocks for rebars.

They all contain the same attributes, the most important: "merk" (mark) and "aantal" (quantity).

JTBWorld — Sun, 29 Nov 2020 23:51:37 GMT

On the Refine Data page, click Combine Identical Rows.
Right-click the column label and choose Combine Record Mode, Sum Values.
The sum of the numerical data is displayed.

W_DE_HOON — Mon, 30 Nov 2020 15:21:21 GMT

Thank you Jimmy for your response.

I've clicked "combine indentical rows", but I can't select Combine Record Mode, Sum Values unless I insert a formula column.

When the table is made, the numbers of brand "AE" are not added together. There is a row with the quantity 2 and a row with 3.

I am not getting a screenshot of the table attached to this post, but what am I doing wrong?

JTBWorld — Mon, 30 Nov 2020 15:50:52 GMT

Try like this.

W_DE_HOON — Mon, 30 Nov 2020 20:21:12 GMT

I have tried your solution, but I still see 2 rows with AE and different quantities.

JTBWorld — Mon, 30 Nov 2020 21:21:48 GMT

Right-click the column label and choose Combine Record Mode > Sum Values. The sum of the numerical data is displayed.

Too bad it's disabled as the attribute value can't be seen as numeric.

Unfortunately you can't do what you want. If you want a custom solution feel free to contact me.

W_DE_HOON — Tue, 01 Dec 2020 19:45:10 GMT

Thank you for your reply. I will contact you through your website.

FraserCorsan — Wed, 23 Oct 2024 17:53:56 GMT

Hello

I have same problem with data extraction: the "combine record mode" function is unselectable.

I have try to change the coloum data format in number and switch on the "identical row combine" option.

Does anyone have a clue about it ?

Thank u