topic Need help with the join condition in QlikView

Need help with the join condition

ashmitp869 — Tue, 17 May 2022 23:57:27 GMT

Hi there ,

if anyone can assist with the join

I am using this condition -

on
app.[Visit ID] ='%' + nap4.[Service Event ID] + '%'
and
app.[Appt Date] =nap4.[Service Date]
and ( app.[Appt Location] Like 'D&A%' and nap4.[Service Unit Name] Like 'D&A%' )

But the join condition is not working

Re: Need help with the join condition

James5654 — Thu, 19 May 2022 03:46:55 GMT

The join condition compares two columns, each from a different table. To execute a join, Oracle Database combines pairs of rows, each containing one row from each table, for which the join condition evaluates to TRUE . The columns in the join conditions need not also appear in the select list. ExpressHR