# Mappers **URL:** https://forum.alumio.com/c/ipaas-transformers-entity-transformers/mappers/26.md [Latest](https://forum.alumio.com/latest.md) · [Categories](https://forum.alumio.com/categories.md) · [Tags](https://forum.alumio.com/tags.md) --- ## [About the Mappers category](https://forum.alumio.com/t/about-the-mappers-category/32)
**Author:** [@Alumio\_Bot](https://forum.alumio.com/u/Alumio_Bot)\ **Replies:** 0
Please use the correct category for your topics. --- ## [Merge keys from 'schema' array into many products](https://forum.alumio.com/t/merge-keys-from-schema-array-into-many-products/2769)
**Author:** [@Ties](https://forum.alumio.com/u/Ties)\ **Replies:** 2\ **Last updated:** [January 22, 2026, 9:51am UTC](https://forum.alumio.com/t/merge-keys-from-schema-array-into-many-products/2769 "2026-01-22T09:51:44Z")
Hi all! I’m trying to process some product data but I’'m running into some issues. The system I’'m extracting the data from supplies a schema which contains the fields in an array before supplying the actual products i… --- ## [Convert string in array to number](https://forum.alumio.com/t/convert-string-in-array-to-number/2059)
**Author:** [@vosy](https://forum.alumio.com/u/vosy)\ **Replies:** 1\ **Last updated:** [June 11, 2025, 7:26am UTC](https://forum.alumio.com/t/convert-string-in-array-to-number/2059 "2025-06-11T07:26:45Z")
\[ "packing\_unit\_2", "packing\_unit\_3" \] how can i get new array of last numbers of this array? \[2,3\] --- ## [How to generate a UUID](https://forum.alumio.com/t/how-to-generate-a-uuid/657)
**Author:** [@kjetil](https://forum.alumio.com/u/kjetil)\ **Replies:** 7\ **Last updated:** [January 6, 2025, 7:21am UTC](https://forum.alumio.com/t/how-to-generate-a-uuid/657 "2025-01-06T07:21:14Z")
Do we have any way to generate a UUID (v4) from a value, e.g. by using a mapper? Edit: I found a String:hash mapper, but I cannot find UUIDv4 algorithm… What I want to achieve is to create a Primary key for a Shopwa… --- ## [How to sort keys in a JSON Object](https://forum.alumio.com/t/how-to-sort-keys-in-a-json-object/1175)
**Author:** [@Gugi](https://forum.alumio.com/u/Gugi)\ **Replies:** 0\ **Last updated:** [June 18, 2024, 12:30pm UTC](https://forum.alumio.com/t/how-to-sort-keys-in-a-json-object/1175 "2024-06-18T12:30:09Z")
Table of Contents Introduction Use case Introduction There are some systems that require you to send a request with ordered keys in the payload. There may be some validations on the server side, which usually involves … --- ## [Cast JSON to string](https://forum.alumio.com/t/cast-json-to-string/1118)
**Author:** [@j.wiegmann](https://forum.alumio.com/u/j.wiegmann)\ **Replies:** 2\ **Last updated:** [May 13, 2024, 10:52am UTC](https://forum.alumio.com/t/cast-json-to-string/1118 "2024-05-13T10:52:36Z")
Hi all. Looking for a way to cast a JSON to a string. Should work similar to https://jsontostring.com/. Is there a way to do this in Alumio? --- ## [Serialize as CSV](https://forum.alumio.com/t/serialize-as-csv/801)
**Author:** [@Rickvzanden](https://forum.alumio.com/u/Rickvzanden)\ **Replies:** 8\ **Last updated:** [May 2, 2024, 11:39am UTC](https://forum.alumio.com/t/serialize-as-csv/801 "2024-05-02T11:39:20Z")
Hi I am looking to export my JSON data as CSV with the serializer. But when I look at the list of options the only thing that comes near is the XLSX version. Unfortunately it has to be CSV and nothing else. When I lo… --- ## [Map epoch timestamp to date](https://forum.alumio.com/t/map-epoch-timestamp-to-date/920)
**Author:** [@daniellefers](https://forum.alumio.com/u/daniellefers)\ **Replies:** 2\ **Last updated:** [January 8, 2024, 7:56am UTC](https://forum.alumio.com/t/map-epoch-timestamp-to-date/920 "2024-01-08T07:56:20Z")
I’m trying to convert an epoch timestamp (1703116800000) to a readable Date Format (2023-12-21 00:00:00) in my entity transformer. What is considered best practice? --- ## [How to do a factorial?](https://forum.alumio.com/t/how-to-do-a-factorial/914)
**Author:** [@robin.speekenbrink](https://forum.alumio.com/u/robin.speekenbrink)\ **Replies:** 7\ **Last updated:** [December 22, 2023, 2:43pm UTC](https://forum.alumio.com/t/how-to-do-a-factorial/914 "2023-12-22T14:43:43Z")
I currently have a structure sort of like the following: \[ { "factor": 1 }, { "factor": 2 }, { "factor": 2 }, { "factor": 4 } \] Where i’d like the total factorial: 1 \* 2 \* 2 \* 4 = 16 ad… --- ## [Trouble formatting as number without thousand separator](https://forum.alumio.com/t/trouble-formatting-as-number-without-thousand-separator/886)
**Author:** [@robin.speekenbrink](https://forum.alumio.com/u/robin.speekenbrink)\ **Replies:** 3\ **Last updated:** [November 27, 2023, 1:53pm UTC](https://forum.alumio.com/t/trouble-formatting-as-number-without-thousand-separator/886 "2023-11-27T13:53:16Z")
Hi, I’d like to format to a number without a thousand separator. (2.6000 becomes 2.60, 2 decimals using “.” or 10000.000300 to become 10000,0003 using “,” and 4 decimals. Both without the thousand separator. The forum n… --- ## [How to trim an empty line from a string](https://forum.alumio.com/t/how-to-trim-an-empty-line-from-a-string/791)
**Author:** [@robin.speekenbrink](https://forum.alumio.com/u/robin.speekenbrink)\ **Replies:** 4\ **Last updated:** [October 24, 2023, 2:05pm UTC](https://forum.alumio.com/t/how-to-trim-an-empty-line-from-a-string/791 "2023-10-24T14:05:16Z")
Seems pretty simple but i have a text value with an empty line. I’d like to ‘trim’ that… (so the value starts with the text instead of a linebreak)) How? --- ## [How to get around a "." in key value?](https://forum.alumio.com/t/how-to-get-around-a-in-key-value/663)
**Author:** [@j.wiegmann](https://forum.alumio.com/u/j.wiegmann)\ **Replies:** 2\ **Last updated:** [July 4, 2023, 8:08am UTC](https://forum.alumio.com/t/how-to-get-around-a-in-key-value/663 "2023-07-04T08:08:53Z")
I have a file which contains key values in which I need the value of the field for the identifier in a storage. Example: { “No.”: “STUB103-727-9M”, “Product\_Number”: “STK-SHIRT”, “Category\_No”: “1907”, “Category\_Nam… --- ## [Value Mapper: String Reverse](https://forum.alumio.com/t/value-mapper-string-reverse/649)
**Author:** [@abubakar](https://forum.alumio.com/u/abubakar)\ **Replies:** 1\ **Last updated:** [June 21, 2023, 7:19am UTC](https://forum.alumio.com/t/value-mapper-string-reverse/649 "2023-06-21T07:19:32Z")
Hello everyone, I am confused on how to perform string reverse in Alumio --- ## [Are there alternatives to the GUI in Alumio?](https://forum.alumio.com/t/are-there-alternatives-to-the-gui-in-alumio/622)
**Author:** [@kjetil](https://forum.alumio.com/u/kjetil)\ **Replies:** 1\ **Last updated:** [June 12, 2023, 10:13am UTC](https://forum.alumio.com/t/are-there-alternatives-to-the-gui-in-alumio/622 "2023-06-12T10:13:35Z")
Do you have a possibility to script etc. for entity transformers in stead of or in addition to the GUI? --- ## [String: Explode to an array](https://forum.alumio.com/t/string-explode-to-an-array/600)
**Author:** [@steven.ferrell](https://forum.alumio.com/u/steven.ferrell)\ **Replies:** 2\ **Last updated:** [May 22, 2023, 1:27pm UTC](https://forum.alumio.com/t/string-explode-to-an-array/600 "2023-05-22T13:27:59Z")
Hello, I have a string that looks like this: { "sku":"1x130F1002P2/2x023F35/1x044F7248" } If I use a value mapper of String: Explode with the delimiter I end up with: { "sku": \[ "1x130F1002P2", "2x023F35"… --- ## [Can we make conditional mapping using JMESPath?](https://forum.alumio.com/t/can-we-make-conditional-mapping-using-jmespath/584)
**Author:** [@kjetil](https://forum.alumio.com/u/kjetil)\ **Replies:** 3\ **Last updated:** [May 12, 2023, 1:31pm UTC](https://forum.alumio.com/t/can-we-make-conditional-mapping-using-jmespath/584 "2023-05-12T13:31:33Z")
Say I have the displayType key that can have the values ‘text’ and ‘select’. Now I would want to map that to TEXT and SINGLESELECT accordingly. I tried the following, that results in an error: “myType”: “&{\[?displayTyp… --- ## [Mapper: Array Merge / Array Push](https://forum.alumio.com/t/mapper-array-merge-array-push/557)
**Author:** [@abubakar](https://forum.alumio.com/u/abubakar)\ **Replies:** 1\ **Last updated:** [April 19, 2023, 5:56am UTC](https://forum.alumio.com/t/mapper-array-merge-array-push/557 "2023-04-19T05:56:53Z")
Hello everyone, Please i would like to know how i can achieve merging two arrays together or copying the data one array into another array sample “old”:\[2,4,6,3,5\] “old1”:\[7,0,1\] EXPECTED RESULT “old”:\[2,4,6,3,5,7,… --- ## [XML to JSON Transformation](https://forum.alumio.com/t/xml-to-json-transformation/481)
**Author:** [@abubakar](https://forum.alumio.com/u/abubakar)\ **Replies:** 10\ **Last updated:** [March 14, 2023, 8:25pm UTC](https://forum.alumio.com/t/xml-to-json-transformation/481 "2023-03-14T20:25:30Z")
Hello @Roland , i want to know more about this, i have used the value mapper → serialize xml, but my data is not transformed --- ## [How to replace everything from string with PCRE / REGEX result](https://forum.alumio.com/t/how-to-replace-everything-from-string-with-pcre-regex-result/155)
**Author:** [@Alumio\_Bot](https://forum.alumio.com/u/Alumio_Bot)\ **Replies:** 3\ **Last updated:** [October 3, 2022, 8:51am UTC](https://forum.alumio.com/t/how-to-replace-everything-from-string-with-pcre-regex-result/155 "2022-10-03T08:51:51Z")
It could happen you have a string and would like to replace everything except what you select with the PCRE / REGEX. For example we have the string: “/ProductImages/image-thumb\_\_14\_\_api\_product\_image/Roundball-1252789.… --- ## [How to get filename from a path string?](https://forum.alumio.com/t/how-to-get-filename-from-a-path-string/154)
**Author:** [@Alumio\_Bot](https://forum.alumio.com/u/Alumio_Bot)\ **Replies:** 1\ **Last updated:** [September 28, 2022, 1:23pm UTC](https://forum.alumio.com/t/how-to-get-filename-from-a-path-string/154 "2022-09-28T13:23:18Z")
Sometimes you need to get an image name or document name from a string in your input data. This is very easy with Alumio. Answer You can get just the filename (with extension) by using the “String: File basename” mappe…