All,
Dim1 contains string values
Dim2 contains patterns
Example:
Dim1 Dim2
ABC C*
ADEF ?D?
I need to do this static pattern matching: Match([Dim1]; “jh”)
dynamically like this: Match([Dim1]; [Dim2])
inside a Webi variable
Any ideas / alternate ways to achieve this??
What version of BOBJ are you using? What’s not working? Have you read the documentation for the Match() function?
Seems to work for me…
@nscheaffer Thanks for the response. v4.3
Here’s what I’m trying to do-
Data Provider1 has Dim1, Meas1
Data Provider2 has Dim2 (which contains patterns like shown in my example)
I need a table with two columns showing:
Dim2 Amount
C3 Sum all Meas1 values in DP1 where Dim1 matches with pattern C3
A8* Sum all Meas1 values in DP1 where Dim1 matches with pattern A8*
Both DPs are merged.
If you can provide some useful sample data I am confident we can get this worked out. Screenshots of your (mocked up) data would provide a better idea of your situation. Creating some free-hand SQL as I laid out here would be even better. Also, what object are your data providers merged on?