ODS column nested array

Hi,

I have to create a booking statistic. The report should contain the booked item and it's nested properties like price, count and description. Please find the data structure below:

Array
(
    [0] => Array
        (
            [description] => Array
                (
                    [0] => Under 35
                    [1] => Full Rate
                )

            [count] => Array
                (
                    [0] => 3
                    [1] => 1
                )

            [amount] => Array
                (
                    [0] => 975.00
                    [1] => 815.00
                )

            [price] => Array
                (
                    [0] => 325.00
                    [1] => 815.00
                )

            [id] => Array
                (
                    [0] => 301317289496975
                    [1] => 301317289496966
                )

            [participantType] => Array
                (
                    [0] => 101245331463914
                    [1] => 101171877794528
                )

        )

    [1] => Array
        (
            [description] =>
            [count] => 2
            [amount] => 74.00
            [price] => 37.00
            [id] => 301317289498143
            [participantType] =>
        )

    [2] => Array
        (
            [description] =>
            [count] => 1
            [amount] => 50.00
            [price] => 50.00
            [id] => 301317289601222
            [participantType] =>
        )
)

Currently my template looks like that:
Currently for booked items with multiple descriptions the report just contains the value array instead of multiple rows each containing the corresponding description value. How can I create those rows with its value?

Thanks and Best regards
Marko

Hi,

any chance of getting a hint into the right direction here?

Thanks
Marko

I think your value as array is too complicated for TBS merging. Especially if they are mixed with classic structure.

Why don't you simply create $data2 which is a copy of your data but with the structure expected by TBS, and then merge this $data2 ?
It would be a small piece of code.

Hi Skrol29,

what would be the most useful datastracture in my scenario for TBS?
If possible I'd like to avoid multiple rows with the same value in column A even if the other columns contain multiple rows - do you know what I mean?

Many thanks in advance.
Best
Marko

The standard data structure is ans array like a recordset, that each record having the same items :

Building this structure is easy in PHP, and you can yourself avoid multiple rows when builing it.

Thanks for your feedback - it's now working as it should be :)
Thanks again for your support!