Counting Arrays and sending data separated by semi-colons

[aditya_gupta41]

Hello Experts,

I have an implementation where I have 2 set of data shown below:

Output1:

Output2

Here, Output1 comes with ‘single entry’ of Z1WSCOPE in an object. And Output2 comes with ‘multiple entries’ in an array.

What I am trying to achieve is:

1. If the input is with single entry, then the output should be MNGRP | MNCOD | LTXA1
2. If the input is with multiple entries, then the output should be MNGRP | MNCOD | LTXA1;MNGRP | MNCOD | LTXA1 (separated by ‘;’)

Thanks in Advance

[Abhishek_Soni37]

Hi @aditya.gupta41 ,

Try this expression:

$Doc.length == 1 ? $Doc[0].keys().join(“|”) : $Doc.map(x => x.keys().join(“|”)).join(“;”)

O/p window:

Sample pipeline:
Test_Expression_2023_06_26.slp (3.6 KB)

Let us know if it works 🙂