hey.. what's the best way to sum a specific field ...
# ask-community-for-troubleshootingl
lenold vaz
02/15/2022, 6:43 AMhey.. what's the best way to sum a specific field from a nested array? (multiple levels in). In the example below, i want to show the sum of all "freight_charges" in the data array
đź‘€ 1
h
Harshith (Airbyte)
02/15/2022, 8:07 AMHey I think you can handle this Custom DBT.
l
lenold vaz
02/15/2022, 2:42 PMhey.. i'm a complete noob to this.. do you'll have any ttutorials or any other resources to help out? I see this as one of the main pieces for us to use across the entire app that i'm making
lenold vaz
02/15/2022, 2:43 PMas the dbt resources also talk about database transaformation and not via api responses
m
Marcos Marx (Airbyte)
02/16/2022, 3:18 AM@lenold vaz Airbyte doesn’t transform (sum, clean, group) your data. You need to apply dbt to execute those operations. Check our docs about how implement a custom dbt transformation: https://docs.airbyte.com/operator-guides/transformation-and-normalization
5 Views