nsingam
Employee
Joined 9 years ago
User Profile
User Widgets
Contributions
Re: Creating elements out of normalized column data for Gravity Forms
Hi, You can use the below expression a mapper followed by a splitter snap. $value.split(“;”)[1].split(“,”).map(x =>$value.split(“;”)[0]+“;”+x) in the above expression, $value is assumed to be the actual source value. The example source json is as follows. [{“value”:“col1;col2”}, {“value”:“ABC;CC1,CC2,CC3”}, {“value”:“DEF;CC1,CC2,CC3”}]3KViews0likes0CommentsRe: Batch records size of 300
Hi @sravankunadi , You are missing the concatenation. where ever your are trying to replace the value dynamically you need to use the " or ' along with +. In your case, the expression should go like below. lib.env.marketo.api+‘rest/v1/leads.json?filterType=id&filterCalues=’+$test+‘&fields=id,active,--------------------’580Views0likes0CommentsRe: How can I test for no rows back from Oracle query
Hi, You can try using the gate snap after Oracle execute snap. Gate snap will always provide the output, even if there is no data then an empty array will be there. In the router check $input0.length > 0 for records else true. Add the splitter snap in the output view of where records were found and split data.3.5KViews1like0CommentsRe: Lookup or Cache to store a value
Hi Amit, Looks like you are trying to read the data from the upstream document. When you use the pipeline parameters you need not use the original field. Instead, you can access the variable using underscore. (ex: _yourVariableName). From the parent, when you are calling the child pipeline also you need to pass the value, so that in the child you will be able you use the same value.1.5KViews1like1Comment