Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have raw data contain site_id,site live date and site close date respectively.
If same site_id will found for next site live date then it should add to count,i.e. now count is 2. but if same site_id found in site close date then it should subtract from count,i.e. its count is now 1
Can any one suggest how to write If Else condition with peek for the same ?
Sure, Will do our best. May be explain from that image as case study ..