1 Reply Latest reply on Sep 13, 2019 9:36 AM by Ken Flerlage

    Identify fields that contain...

    tb582

      I have a CSV file with a bunch of columns... one of them is status, which is a field which I split ALL on a custom value, which creates N new split fields. I then pivot these N fields, in order to further refine via a single status Split field, creating a cal field called timestamp (ephoc). From there I aggregate on on the MAX timestamp field grouped by a unique value. Finally this gives me all the LATEST timestamps along with their unique value. My question is how do I sucessfully join or merge this back into my intial pivot and then filter my pivot 'Status Split'

       

      Initial splits:

       

      split.png

       

      Pivot:

      pivot.png

       

       

      Aggergate

      agger.png