Posts

Showing posts with the label join operations

T) Can using lookup function can you achieve full outer join ?

    Only left or right join can be achieved as we can’t pull uncalled records from lookup file.  E.g. Input file have below 3 records:               ID              1              2             3                         ID Name                         1    A                         2    B                         3    C                         4    D                         5    E    Suppose now you have used lookup functio...