Link the elements of each of the multiple array data by array number

After API call data was flattened at data action, we have multiple arrays of data as shown below, I want to organize each element according to the order of the arrays.
By the way, the number of data in this array will always change because this array data is dynamic.

{
"result.resultBody.USTimeTable": [
[
"0000",
"1111",
"2222",
"3333",
"4444"
],
[
"2222",
"3333",
"4444",
"5555",
],
[
"0000",
"0123",
"1445",
"1567",
"1456",
"1345"
]
],

"result.resultBody.USDate": [
"20220220",
"20220221",
"20220222"
],

What I am expecting is to be organized at Architect like below

20220220 "0000", "1111", "2222", "3333", "4444"
20220221 "2222", "3333", "4444", "5555",
20220222 "0000", "0123", "1445", "1567", "1456", "1345"

Could you please help to check?

Assuming before being flattened they were part of the same object
result.resultBody.USTimeTable[0] will be related to result.resultBody.USDate[0]
result.resultBody.USTimeTable[1] will be related to result.resultBody.USDate[1]
etc

So in Architect if you want the USTimeTable results for 20220222 you can just do
Int Task.PositionIndex = 3 (or whatever you are using it iterate through or select specific items)
Date = GetAt(UsDate, Task.PositionIndex) to get the Date, and then TimeTable Collection = GetAt(USTimeTable, Task.PositionIndex)

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