Forum Discussion

kindminis's avatar
kindminis
New Contributor
3 years ago

Invalid input data - Aggregate snap

I am building a pipeline that joins some data and then aggregate downstream. However, one of the fields that I am grouping by contains nulls and it gives me this error: Invalid input data.

Failure: Invalid input data, Reason: Missing field in the input data at $[‘Region’], Resolution: Please make sure input data have valid value at $[‘Region’]

If I add this in a mapper before the aggregate, then it will work but does not give me the results I need since I want to aggregate on nulls.

match $[‘Region’]
{ null => “”, _ =>$[‘Region’] }

How do I solve this? Thanks!

  • Aleksandar_A's avatar
    Aleksandar_A
    Contributor III
    2 years ago

    Hello gregbowers,

    It would be helpful if you can share more details about on which data source you are receiving the error, and what Account Type are you using.

    For that, you can refer to the Pipeline Statistics section.

     

    Regards,

    Aleksandar.