HOW TO: store multiple records in a string

Integrator.io
1

how to store multiples input field data in a string.

Lets say i want to save PO num,vendor name,EAN code,article number,transport id..etc in a single string(separated by any delimiter ) and later map it to a destination field.

dummy_string = PO num + VN name+EAN code+Article Num

2

@dipayansamanta, are you asking at which point in your flow you could build this string and make it available downstream?

You have a few possibilities, depending on where the other fields have been retrieved or further manipulated. The easiest solution would be directly in import field mapping with simple string concatenation (no "dummy_string =" assignment would be needed).

Export field (source_app):
{{PO num}}|{{VN name}} ...

You could also add dummy_string as a field to your records with its value as the concatenated string, earlier in the flow, in a similar template or via JavaScript.

3

I was saying like picking data from specific REF,BGM,PIA,LIN segment data and gather for Label creation purpose for items.

BGM+105+4502418829+9
DTM+2:20200114:102
NAD+CN+253393::92++Abcd Vendor
LIN+1++6410405066640:EN
RFF+WS:002
RFF+ZZ4:12345

For example, concatenating the above values to create label. It can be stored in the export of the flow or in import.

Later it can be populated in a free-format field in Netsuite sales order for further use.

4

Thanks, @dipayansamanta, for the clarification.

Are you able to see the EDI fields in your integration? Look in export preview data for the raw JSON; or in the drop-down lists of transforms, filters, or import mapping.

As long as you know the field names (or array members), you should be able to concatenate the values for importing the string you need.

5

Thank you Stephen.

Can you help me to write a rule in the transformation which can pick specific REF data from the group?

Like in the above sample data, the LIN group has multiple REF segments,but if I want to pick REF+ZZ4 data then what i should right?

[Segment Group 25][*].RFF[*].REFERENCE.[Reference qualifier =="ZZ4"][Reference Number]] --> [Segment Group 25][*].[REF_String]

is it correct?

Also please mention how i can store multiple values in a sample Jason field(like REF_String) in the transformation rule.

6

Hi, @dipayansamanta. I don't want to steer you wrong. Without more details (which this forum isn't really designed for) and some trial and error, it would be a stab in the dark.

Would you be able to pursue an answer by opening a support ticket, at the top?