Pipeline Looping Through an Array

Question

Hi guys, I am new to Pipeline, and I need some help doing the following task:&nbsp;
Loop through the first half of a text field containing many numbers separated by ";", and comparing each number to the record ID. It accepted the code but when I run it, this code popped up "Skipped because set values are the same as in source object."&nbsp;
{% set array = a.j_classification.split(';') %}
{% set first_half = array | length %}
{% set first_half = first_half//2 %}
&nbsp;
{% for i in range(first_half) %}
{% if array == a.id %}
{{1}}
{% endif %}
{% endfor %}------------------------------Jay------------------------------

prashantmaheshw · Answer

Can you post some sample data ?&nbsp; I visualize you've something like&nbsp;
ABC123 , you want to split it down the middle into ABC and 123 and then compare 123 to the record id of the record ?&nbsp;
it can ABCDE12345, will it always be half the length ? never ABC13245 , since [Record ID#] keeps growing------------------------------Prashant Maheshwari------------------------------

jay · Answer

Prashant - thank you for your response!
An example of a.j_classification field would be "538 923 239 248 492 964 082 943". 
When pipeline loop through each record, I want to compare the record ID to the 1st four number of the a.j_classification field. 
Ex: if record IDs are 538 923 239 248, then I want to output "1" for the new field. So 4 records will be updated.&nbsp;
------------------------------Jay------------------------------

prashantmaheshw · Answer

I am still confused by "Loop through the first half of a text field containing many numbers separated by ";" .
In string already without the text component &nbsp;"538 923 239 248 492 964 082 943" ??
Should we assume we are doing a nested lookup?&nbsp;

------------------------------Prashant Maheshwari------------------------------

jay · Answer

I am sorry for confusing you.&nbsp;
What I meant by "Loop through the first half of a text field containing many numbers separated by ";" is that: The text field contains many numbers such as "538 923 239 248 492 964 082 943", and I only want to compare the first 4 numbers of the field to the record ID.&nbsp;&nbsp;
Hopefully that clarifies the confusion.&nbsp;------------------------------Jay------------------------------

prashantmaheshw · Answer

OK , I understand some part now .
So let's walk through high logic , my assumption is&nbsp;

Array variable is supplied once
Record id is supplied once&nbsp;
If below works you can supply xyz = a.j_classification

{% set xyz = '538;923;239;248;492;964;082;943' %}
{% set values = xyz.split(';') %} --&gt; We split your array&nbsp;
{% for value in values %} &nbsp;-&gt; For each value we now loop through them&nbsp;
{% if value == a.id %} -&gt; We check each value for record.id which I assume is in a.id but you can supply anything
Do something&nbsp;
{% endif %}
{%&nbsp;endfor %}

------------------------------Prashant Maheshwari------------------------------

Forum Discussion

Pipeline Looping Through an Array

8 Replies

Related Content

Help with Pipeline, loops and emails

Pipeline - Bulk Upsert - Continuous Loop

Creating a 'foreach' style loop in pipelines

Pipeline Make Request - Return Make Request JSON Output into fields

Duration Fields with Pipelines

Recent Discussions

Bug with Advanced Query in Pipelines Designer?

Date value changes when copied to new table with pipeline.

Share your feedback on the new Qrew Discussions

'Is Set' in Pipelines

Time of Day field values are not in 24-hour format in Pipelines