Forum Discussion

bcole's avatar
bcole
New Contributor
3 years ago

Evaluating an array value that's nested in a Group By Field and Routing the Group By Level based on Array value

I have created a Group By Field on an Order Number. Underneath that order number I have an array of AI_Status values. I would like to assess the entire array if any of the AI_Status values with the...
expression_language
sample_pipeline
darshthakkar's avatar
darshthakkar
Valued Contributor
2 years ago
Copy LinkReport

Hi mkadange,

Welcome to SnapLogic and community. Yes, you can simply drag and drop the columns on the target path as you did for input/expression. Please try that out once for a small set and selecting All and dropping it on the target will do the needful.

Also, let's assume, out of 400, you need to select 40 which are not in the order, drag and drop will automatically map it for you.

Please keep us posted with your results.

Regards,

Darsh

  • bcole's avatar
    bcole
    New Contributor
    3 years ago
    Copy LinkReport

    Hi Bojan,

    I think I figured it out. Perhaps the diagram below can show you what I was asking. I wanted to pull data from one early snap and get that information back way further down the pipeline.

    I needed to join some of my original data from the first SQL Server JSON response with Data from my SQL Store Procedure call: I was asking for the preferred way of making that happen. Below is what I came up with. Unless you have a better idea, I think we can consider the case closed.

    The expression you sent was great, but how would I know to use the “match” with the filtering. I have taken your Expression training class, but I would like to know another resource that can help me learn to create all the complicated Expressions I will need going forward. Also I tried using jsonPath to reach a solution. Some of the jsonPath would work on online validators, but would not inside various snaps.

    Where do you point people to learn the brand of jsonPath that works here?