Forum Discussion

sshaik's avatar
sshaik
New Contributor III
3 years ago
Solved

How to perform looping for multiple columns to get a single column data

If Iteration 1 then I have to concat all the columns with some special characters and spaces. If the iteration goes to 2nd time them concat all the columns with some special characters and spaces lik...
  • j_angelevski's avatar
    j_angelevski
    4 years ago

    Hi @NAl,

    The second expression is wrong because that way if the Status is ‘X’ or ‘Y’ or ‘Z’ it will return true to both outputs.
    You should change the second expression to $Status != "X" && $Status != "Y" && $Status != "Z", this way it will only evaluate to true if status is neither x, y nor z.
    Also first expression should be: $Status == "X" || $Status == "Y" || $Status == "Z"

ptaylor's avatar
ptaylor
Employee
4 years ago
Copy LinkReport

Sorry, I’m finding this a very confusing post.

Is that related to the paragraph before it or the one after it? I’m not seeing anything else about joins.

What do you mean by “going blank”? What’s supplying that data?

We need more context to make sense of this. What’s a brand new record? From where? It sounds like you might want to change the snap that updates Salesforce to Execute only so that validation doesn’t perform updates that you only want to happen during execution.

Please use “validate” and “execute”, not “compile” and “run”. There’s nothing in SnapLogic that’s really equivalent to “compiling” so that’s a confusing term.