Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two date fields AdmDT and StartDt.
Can I display only the dates that match?
=If(AdmDate = StartDt)
May be create a flag in the script
If(AdmDate = StartDt, 1, 0) as MatchFlag
and then use the flag in your set analysis
Sum({<MatchFlag = {1}>}Measure)
Hi Robert,
Solution 1:
While do the data modelling we need to set a field based on the match.
The we can display based on the field.
Solution 2:
You can delete the unmatched records from the temp table and load the remaining data.
Regards,
Rajesh R. S.