Submitted Questions

  • Scenario

    I have customer details as below, cust_card_no item amount 10001 pen 10 10001 copy 20 10001 pen 10 10001 copy 20 10001 copy 20 now my question is to find the distinct count of item per customer and total ammount spend by a customer?

    Saikumar

    • Aug 14th, 2019

    Count scenario: output will be 2 -------------- Take Partition by key and sort component and key as "{item}" then after Take Dedup sort component and key as "{item} and keep as "first" then after ...

    Shrinidhi SHetty

    • May 6th, 2019

    Use Rollup component, and in transform specify Key as {cust_card_no; item} and transform as out :: rollup(in) = begin out.cust_card_no:1: in.cust_card_no; out.item:2: in.item; out.total::...