Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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!
Hi,
Follow these steps:
Jordy
Climber
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.
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!
Thanks a lot. very helpful 😊