--- cuppy_hub: salesforce cuppy_path: reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/array-transform.md cuppy_section: docs cuppy_doc: 1Y8G-9M4Q cuppy_doc_uuid: e353a236-5cd8-4c2d-91fb-ae0d06dd4e3f cuppy_permalink: https://cuppy.io/salesforce/d/1Y8G-9M4Q cuppy_version: 1 cuppy_updated: 2026-10-23T16:16:52.575Z cuppy_canonical: https://cuppy.io/salesforce/docs/reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/array-transform cuppy_mcp: https://cuppy.io/mcp cuppy_body_sha256: 5147c961715cc79664002c7a41fde64bb663a64007af915416f36e924c605530 # cuppy_body_sha256 is over the document body ALONE, excluding both generated blocks. --- > Mirror of (Salesforce, Data 360 Query Guide), read 2026-10-23. Salesforce's own page is the authority; this copy exists because that site refuses non-browser readers. ## `ARRAY_TRANSFORM` **Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API Applies a lambda expression to each element (or corresponding elements from multiple arrays) and returns a new array with the transformed values. * ``: The first input array. * ``: A lambda expression that defines the transformation. The number of parameters in the lambda must match the number of input arrays. * `, ...`: Additional input arrays. When multiple arrays are provided, the lambda receives corresponding elements from each array. All arrays must have the same length. Returns an array with the same length as the input arrays, where each element is the result of applying the lambda expression to the corresponding input element(s). Returns NULL if any input array is NULL. * All input arrays must have the same length. Mismatched lengths result in an error. * NULL elements in the input arrays propagate through the lambda. If any input element is NULL, the corresponding output element is typically NULL (depending on the lambda expression). * The lambda’s return type determines the output array’s element type. If the lambda returns only NULL, you must explicitly cast it to a specific type. * Empty arrays return an empty array. Double each element in an array. Returns `[2, 4, 6]`. Add corresponding elements from two arrays. Returns `[11, 22, 33]`. Concatenate corresponding strings from two arrays. Returns `["hello world", "good bye"]`. Use CASE to apply conditional logic. Returns `[4, 5, 6]`. Compare corresponding elements and return boolean results. Returns `[false, true, false]`. Combine elements from three arrays. Returns `[9, 12]`. NULL elements propagate through the transformation. Returns `[5, NULL, 9]`. Use nested calls to chain transformations. Returns `[40, 120]`. * [Lambda Expressions](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/lambda-expressions.html) * [ARRAY_FILTER](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/array-filter.html) * [Array Data Type](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/array.html) --- You are reading one file. The same content is free over MCP at https://cuppy.io/mcp with no signup: ranked search across all 376 documents in this hub, the merged view when you work in a layer, known workarounds matched to the error you hit, and depth control so you spend tokens on what you need. Start with the `_hello` tool. How to connect: https://cuppy.io/salesforce/ Something wrong in this document? Report it with the `session feedback` tool on the same endpoint.