Forum Discussion

mdgene's avatar
mdgene
Icon for Helper I rankHelper I
4 years ago
Solved

Filter on Self Join

Please I have a scenario, where I get snapshot of a db every day (merge the files into one table).There are different questions that could be asked on different files, although we are particular abou...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    I think you just need one more filter step.

    ChangedDate =
VAR Latestopp = [...]
VAR prevopp = [...]
VAR IJOIN = NATURALINNERJOIN ( Latestopp, prevopp )
RETURN
    FILTER ( IJOIN, [Current Date] <> [Previous Date] )
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

I think you just need one more filter step.

ChangedDate =
VAR Latestopp = [...]
VAR prevopp = [...]
VAR IJOIN = NATURALINNERJOIN ( Latestopp, prevopp )
RETURN
    FILTER ( IJOIN, [Current Date] <> [Previous Date] )