3 Replies Latest reply on Jun 13, 2018 5:14 AM by Andrea Reynolds

    1 request broken into steps. Only 1 step contains a value needed for each step under the request.

    Andrea Reynolds

      I have a data set where a request has been broken out into steps. Only step 10 of each request contains the client information. I need each step with the same request ID to pull the client it is linked to from step 10.

      The example below I did a formula calling out specific request IDs and tell them what to be. It is not a feasible solution since there are millions of request IDs and we are constantly adding new ones. So its just an example of what it needs to look like.

      There has got to be an easier way!