DataWeave programming challenge #1: Add numbers separated by paragraphs and get the max number

---

Other posts from this series:

1. DataWeave programming challenge #1: Add numbers separated by paragraphs and get the max number

2. DataWeave programming challenge #2: Rock Paper Scissors game score system

3. DataWeave programming challenge #3: Count palindrome phrases using the Strings module

4. DataWeave programming challenge #4: Solve the Tower of Hanoi mathematical puzzle

5. DataWeave programming challenge #5: Reverse a phrase's words, but keep the punctuation

6. DataWeave programming challenge #6: Using tail-recursion to get the factorial of a number

7. DataWeave programming challenge #7: Modify certain values from a JSON structure

8. DataWeave programming challenge #8: Sum all digits to get a 1-digit number

---

In this post:

• Input

• Explanation of the problem

• Expected output

• Clues

• Answer

---

This challenge is based on Advent of Code 2022 day 1

Try to solve this challenge on your own to maximize learning. We recommend you refer to the DataWeave documentation only. Try to avoid using Google or asking others so you can learn on your own and become a DataWeave expert!

Solve on the Playground

Input

Consider the following input payload (can be of txt format):

1
2

3
4
5
0

15

20
5
1
3

25

6
4
4

Explanation of the problem

Create a DataWeave script to add all the numbers separated by a paragraph.

For example,

• the first number would be 3 (2 + 1),

• the second number would be 12 (3 + 4 + 5 + 0),

• the third number would be 15, and so on.

After that, retrieve the highest number.

(Using code, not manually 😉)

Expected output

In this case, the expected output would be:

29

Clues

If you're stuck with your solution, feel free to check out some of these clues to give you ideas on how to solve it!

Clue #1

Use the splitBy() function

Clue #2

Instead of splitting by "\n" try splitting by "\n\n" at first - to separate by paragraph

Clue #3

Use map() to go through each paragraph

Clue #4

Use splitBy() again to separate each of the paragraph's lines

Clue #5

Use sum() to add all the numbers in each paragraph

Clue #6

Use max() to return the highest number from the array

Clue #7

If some of the numbers are string instead of numbers, use `as` to coerce them to Numbers -- this is a bug and will hopefully be fixed soon!

Answer

If you haven't solved this challenge yet, we encourage you to keep trying! It's ok if it's taking longer than you thought. We all have to start somewhere ✨ Check out the clues and read the docs before giving up. You got this!! 💙

There are many ways to solve this challenge, but you can find here some solutions we are providing so you can compare your result with us.

Solution #1

%dw 2.0

output application/json

---

(payload splitBy "\n\n")

map (sum($ splitBy "\n") as Number)

then max($)

Solution #2

%dw 2.0

output application/json

---

(payload splitBy "\n\n")

map ((item) -> (

sum(item splitBy "\n") as Number

))

then max($)

Solution #3

%dw 2.0

output application/json

---

(payload splitBy "\n\n")

map ((item,index) -> do {

var newItem = item splitBy "\n"

---

sum(newItem) as Number

})

then max($)

Solution #4

%dw 2.0

output application/json

---

max((payload splitBy "\n\n")

map (sum($ splitBy "\n") as Number))

Feel free to comment your code below for others to see! 😄

Did you like this challenge?? Let us know what you think!! 👇

Subscribe to receive notifications as soon as new content is published ✨

Next Challenge