# Need help in formatting data from nested array node with code node

**URL:** <https://community.n8n.io/t/need-help-in-formatting-data-from-nested-array-node-with-code-node/26625>\
**Category:** Questions\
**Tags:** data-transformation\
**Created:** [May 29, 2023, 6:10pm UTC](https://community.n8n.io/t/need-help-in-formatting-data-from-nested-array-node-with-code-node/26625 "2023-05-29T18:10:40Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Siya](https://avatars.discourse-cdn.com/v4/letter/s/4491bb/32.png) [@Siya](https://community.n8n.io/u/Siya)\
**Post date:** [May 29, 2023, 6:10pm UTC](https://community.n8n.io/t/need-help-in-formatting-data-from-nested-array-node-with-code-node/26625/1 "2023-05-29T18:10:40Z")

</div>

I need help in transforming data in array

## What is the error message (if any)?

No error, I need help with data transformation. I have 2 dependency files which needs to be formatted , each is of different type, First one is seperated by colon and I need 1 and 2 nd name from each row.(Note they are seperated by colon)

Second file each row first name (note the columns are sperated by space ) The output needs to be as I shared below . Please help… !!!  
@Jon , Kindly help. Any details , pls let me know.

## Please share your workflow

## Share the output returned by the last node

```auto
[
{
"keywords":[
"com.fasterxml.jackson.core",
"jackson-databind",
"jackson-annotations",
"com.fasterxml.jackson",
"jackson-bom",
"jackson-core",
"com.fasterxml.jackson.dataformat",
"jackson-dataformat-cbor",
"jackson-dataformat-properties",
"jackson-dataformat-xml",
"jackson-dataformat-yaml",
"com.fasterxml.jackson.datatype",
"jackson-datatype-jdk8",
"jackson-datatype-jsr310",
"com.fasterxml.jackson.module",

```

## Information on your n8n setup

- **n8n version:**
- **Database (default: SQLite):**
- **n8n EXECUTIONS\_PROCESS setting (default: own, main):**
- **Running n8n via (Docker, npm, n8n cloud, desktop app):**
- **Operating system:**

---

<div class="post-metadata">

**Author:** ![MutedJam](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/mutedjam/32/70851_2.png) [@MutedJam](https://community.n8n.io/u/MutedJam)\
**Post date:** [June 5, 2023, 3:03pm UTC](https://community.n8n.io/t/need-help-in-formatting-data-from-nested-array-node-with-code-node/26625/2 "2023-06-05T15:03:50Z")

</div>

Hi @Siya, I am sorry you’re having trouble.

It seems your example workflow doesn’t include any example data using which the problem can be seen. Perhaps you can share an example of the data you are sending to your Code node and the result you’d like to see coming from your code node?

---

<div class="post-metadata">

**Author:** ![system](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/system/32/36532_2.png) [@system](https://community.n8n.io/u/system)\
**Post date:** [September 3, 2023, 3:04pm UTC](https://community.n8n.io/t/need-help-in-formatting-data-from-nested-array-node-with-code-node/26625/3 "2023-09-03T15:04:31Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.