Answered Questions

  • 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?

    • May 2nd, 2017

    Use the override-key option in join parameter, but the key should be of same data type. It will perform as per join type you mentioned

  • 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?

    Iffath

    • Dec 13th, 2023

    Use Rollup with key as id and in transform use sum() function. mention fields as nullable in dml"mysql out::rollup(in) = begin out.id :: in.id; out.col1 :: sum(in.col1); out.c...

    Vishnu

    • Dec 12th, 2023

    Does it works on GDE 1.1