-
Multifiles with Join
What is behavior of join with multifiles if I use Join via common key in both files and if the key is different what is the result?
-
To get only Not NUll Values
Suppose I have a scenario like below: Input: ====== Id Col1 Col2 a 100 Null a Null 200 b 300 Null b Null 400 And I need output as: Output: ======= Id Col1 Col2 a 100 200 b 300 400 How to get only Not NUll Values?