Advanced data extraction

[W_DE_HOON]

I have made a number of different blocks for rebars.

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

See also the attached file.

I want to create a bar bending schedule using the command "dataextraction".

I get a table with a row for each placed block.

What I would like is that all rows with the same attribute “merk” are merged together into a single row and the corresponding values of the attribute “aantal” are summed.

Is this possible with the command “dataextraction” or another autocad command?

Or should I start thinking more in the direction of LISP or VB.net?

[JTBWorld]

1. On the Refine Data page, click Combine Identical Rows.
2. Right-click the column label and choose Combine Record Mode, Sum Values.

   The sum of the numerical data is displayed.

[W_DE_HOON]

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]

Try like this. 

[W_DE_HOON]

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

[JTBWorld]

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]

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

[FraserCorsan]

 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