Wildmatch to exclude all dimensions and match with unlinked field

[Ashish_1102]

Dear community -

I've a straight table like this -

Pid        Pname                   Min Date                                                       Title                         PubDate

299      G Eq Qu                02-Apr-2018                                                   G Eq Quart             25-Mar-19

                                                                                                                                                02-Apr-2018

                                                                                                                  XYZ                        01-Oct-2018

Where Pid and Pname are dimensions and min date is an expression.

I've 2 other fields called title and Pub-date in another table and is not linked to either Pid or Pname.

The logic to calculate min date expression is - to wildmatch Pname with title, and if there's a match then pick the minimum  PubDate associated to it.

Could anybody please help me in constructing such an expression.

many thanks in advance.

[JordyWegman]

Hi,

Follow these steps:

1. Rename Title to Pname. This way they are connected.
2. Create a table and put Pid and Pname in the table as dimensions
3. Add Min(PubDate) in as a calculated dimension

Jordy

Climber

[Ashish_1102]

Hi Jordy

Thanks for the prompt reply.

Sorry I wasn't very clear.

PName and Title can't be linked. infact Pname would be a substring of Title, hence I've to wildmatch and then pick the minimum published date corresponding to Title.

Hope that makes sense.

[andrei_delta · Accepted solution]

hi,

i attached an app as an example.

If you want to do the wildmatch pname should be the mask and title the string you are going to look into.

Hope it helps!

[Ashish_1102]

Thanks a lot. very helpful 😊