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