Array of events

ksqlDB
1

Hi all, I need a help, I have a typical customer and orders events. I want to create a table with one single row with customerid and an array of struct with orders, any ideas?
orders

2

@achong can you share a bit more detail? e.g. full payload example, desired payload, etc
Half a screenshot is hard to work with :slight_smile:

3

Hi @rmoff ,check payload

[
  {"CUSTOMERID":"8484214343400844",
   "ORDERDATA":
     {
      "ItemName":"Jelly Comb folding Bluetooth keyboard",
      "orderID":"799991",
      "StorePickUpFlag":"No",
      "OrderDate":"06/24/2019"
     }
  },
  {"CUSTOMERID":"8484214343400844",
   "ORDERDATA":
    {
     "ItemName":"Jelly Comb folding Bluetooth keyboard",
     "orderID":"799991",
     "StorePickUpFlag":"No",
     "OrderDate":"06/24/2019"}
  }, 
  {
   "CUSTOMERID":"5759544343400808",
   "ORDERDATA":
   {
    "ItemName":"Apple TV 4K Streaming Console",
    "orderID":"799992",
    "StorePickUpFlag":"No",
    "OrderDate":"01/28/2020"}
   },
   {
    "CUSTOMERID":"6454214343400548",
    "ORDERDATA":
    {
     "ItemName":"Jelly Comb folding Bluetooth keyboard",
     "orderID":"799993",
     "StorePickUpFlag":"No",
     "OrderDate":"06/24/2019"
    },
   },
   {
    "CUSTOMERID":"6454214343400548",
    "ORDERDATA":
    {
     "ItemName":"Nintendo Switch",
     "orderID":"799994",
     "StorePickUpFlag":"Yes",
     "OrderDate":"09/01/2018"
    }
   },
   {
    "CUSTOMERID":"8484214343400844",
    "ORDERDATA":
    {
     "ItemName":"Apple iPad",
     "orderID":"799995",
     "StorePickUpFlag":"Yes",
     "OrderDate":"01/28/2020"
    }
   },
   {
    "CUSTOMERID":"8484214343400844",
    "ORDERDATA":
    {
     "ItemName":"Tile Mate Item Finder 4-Pack Combo",
     "orderID":"799996",
     "StorePickUpFlag":"No",
     "OrderDate":"01/28/2020"
    }
   },
   {
    "CUSTOMERID":"5759544343400808",
    "ORDERDATA":
    {
     "ItemName":"Arlo Pro",
     "orderID":"799997",
     "StorePickUpFlag":"Yes",
     "OrderDate":"06/24/2019"
    }
   },
   {
    "CUSTOMERID":"8484214343400844",
    "ORDERDATA":
    {
     "ItemName":"Nintendo Switch",
     "orderID":"799998",
     "StorePickUpFlag":"Yes",
     "OrderDate":"01/28/2020"
    }
   },
   {
    "CUSTOMERID":"8484214343400844",
    "ORDERDATA":
    {
     "ItemName":"Apple TV 4K Streaming Console",
     "orderID":"799999",
     "StorePickUpFlag":"No",
     "OrderDate":"09/01/2018"
    }
   },
   {
    "CUSTOMERID":"6454214343400548",
    "ORDERDATA":
    {
     "ItemName":"Apple iPad",
     "orderID":"800000",
     "StorePickUpFlag":"No",
     "OrderDate":"09/01/2018"
    }
   }
]
4

My desire is customerid with array or orders

  {
     "CUSTOMERID":"8484214343400844",
      "ORDERDATA":
      [
          {
             "ItemName":"Jelly Comb folding Bluetooth keyboard",
             "orderID":"799991",
             "StorePickUpFlag":"No",
             "OrderDate":"06/24/2019"
          },
           {
              "ItemName":"Apple iPad",
              "orderID":"799995",
              "StorePickUpFlag":"Yes",
              "OrderDate":"01/28/2020"
           },
           {
              "ItemName":"Tile Mate Item Finder 4-Pack Combo",
              "orderID":"799996",
              "StorePickUpFlag":"No",
              "OrderDate":"01/28/2020"
            },
            {
                "ItemName":"Nintendo Switch",
                "orderID":"799998",
                "StorePickUpFlag":"Yes",
                "OrderDate":"01/28/2020"
            },
            {
                "ItemName":"Apple TV 4K Streaming Console",
                "orderID":"799999",
                "StorePickUpFlag":"No",
                "OrderDate":"09/01/2018"
            }
      ]  
  },
  {
   "CUSTOMERID":"5759544343400808",
   "ORDERDATA":
    [
         {
            "ItemName":"Apple TV 4K Streaming Console",
            "orderID":"799992",
            "StorePickUpFlag":"No",
            "OrderDate":"01/28/2020"
         },
         {
            "ItemName":"Arlo Pro",
            "orderID":"799997",
            "StorePickUpFlag":"Yes",
            "OrderDate":"06/24/2019"
         }
      ] 
   },
   {
    "CUSTOMERID":"6454214343400548",
    "ORDERDATA":
     [
       {
          "ItemName":"Jelly Comb folding Bluetooth keyboard",
          "orderID":"799993",
          "StorePickUpFlag":"No",
          "OrderDate":"06/24/2019"
       },
       {
         "ItemName":"Nintendo Switch",
         "orderID":"799994",
         "StorePickUpFlag":"Yes",
         "OrderDate":"09/01/2018"
       },
       {
          "ItemName":"Apple iPad",
          "orderID":"800000",
          "StorePickUpFlag":"No",
          "OrderDate":"09/01/2018"
       }
     ] 
}
5

This topic was automatically closed after 30 days. New replies are no longer allowed.