count amount of nr by match between two columns in two tabels

[#1]

Hi comm,

I have the following problem.

I want to count the article_nr of table1 by a type_string from table2 that is a part of an element_string from table.

I think I need count, wildmatch and aggr or set analysis.

I tried a lot but I couldn't find the right formular.

so for example i have

in table 1

nr    element_string  .... 

1     11(2)230          .....   

2     11(2)230           ......

3     12(2)330          .....

4     11(2)230           ....

5     09(4)234              .....

in table i want to show

type_string     amount

230               3

330               1

234               1

hopefully I have explained it in a way u guys understand it.

Thx for an answer.

[Anonymous]

The most natural thing to do is to create type_string field in the table 1, for example:

right(element_string,3) as type_string

or

subfield(element_string, ')', 2) a type_string

[#3]

yeah allready thoughed about this. im editing the load script atm