Igor,
thank you again. I have the .exe now and it seems like the setup you mentioned works.
You need to set 0(zero) in max. error count for that to work. Docs says nothing about it.
Now i will test it witl large batches.
cheers
Simon
PS. In INSERT mode, it says - table not empty, even if table is empty, but i will do another post about it.
@pmancevski Thank you for the quick response. It helped.
@pmancevski How to apply the same logic on group by values. Sample data is attached below. Sum should be incremented by 10 for each row.
[
{
“groupBy”: {
“number”: “1115122”
},
“group”: [
{
“name”: “TD”,
“number”: “1115122”,
“sum”: “390”
},
{
“name”: “TD”,
“number”: “1115122”,
“sum”: “390”
}
]
},
{
“groupBy”: {
“number”: “1115982”
},
“group”: [
{
“name”: “TD”,
“number”: “1115982”,
“sum”: “390”
}
]
},
{
“groupBy”: {
“number”: “1115962”
},
“group”: [
{
“name”: “TD”,
“number”: “1115962”,
“sum”: “390”
}
]
}
]
required output:
1st group : sum=400, 410
2nd group : sum=400
3rd group : sum=400
