I have used the transform which the output looks like this.
"payload": {
"_doc": {
"TransactionAmount": [
50000,
565
],
"CompanyName": [
"C Store",
"A Store"
],
"TransactionAmountAllowed": [
11000,
105
],
"StoreName": [
"C Store",
"A Store"
],
"CreatedAt": [
"10/10/2017 16:48",
"11/10/2017 17:05"
],
"PhoneNumber": [
33333333,
11111111
],
"TransactionID": [
4,
5
]
}
But the data are all grouped together like this.
How can I separate the record and to create two entries?