I am trying to find out how to make a count based on parameters read from e.g. an excel file.
I have the following scenario:
A transaction table where the users needs to know how many occurrencis there is from OldValue in Field1 to NewValue in Field2, this can obvioulsy change and I wanted to place the parameter in an excel file that will be imported.
I have not managed to find out how to count the number of occurencies in the transacton table
Col1 Col2 Col3 Col4 Col5
Trans1 Text1 OldRef1 NewRefA 1234
Trans2 Text2 OldRef1 NewRefA 12
Trans3 Text1 OldRef1 New 1111
Trans4 Text3 OldRef2 NewRefAB 1234
Trans5 Text2 OldRef2 RefA 1234
With the data above would I like to get a result of 2 for the first case(OldRef1 -> NewRefA) and 1 for the second(OldReF2 -> NewRefB)
Help would be appreciated or if I should do this n another way.
I need to oad the entire transaction table since there are a lot of oter thinf that needs to be investigated based on this data, This calculation is just one small part of several KPI's that I want to display.
The data is also used for investigations and so on.