Most RecentMost ViewedMost LikesRecord Count per file Hi, I am reading multiple csv files from a SFTP location. I need to get the # of records per file, so I can put that info in a summary email. Any ideas on how I can retrieve the filename and # of records for each file? Thanks! Dawn Aggregate Snap - CONCAT function - input contains nulls / undefineds Judging from the options available in the Aggregate Snap, I would expect it to work much like the identically named aggregate functions in SQL. SQL functions like COUNT, AVG, SUM, and MAX conveniently skip over NULLs and return the same values as they would if the NULLs were not there. However, for CONCAT this does not appear to be the case. I am running into problems when the attribute I am trying to aggregate from the document stream either does not exist or is null. For example, if I had $original.foo as the input field in the document stream that looked something like (‘abc’, ‘xyz’, null, ‘aa’, undefined, ‘bb’) and was mapping CONCAT of that to an output field “bar”, I would expect bar to look like: “abc|xyz|aa|bb”. Instead I get errors: ‘foo was not found while evaluating the sub-expression “$original.foo”’ and ‘$original.original.LegacyKey is undefined. Perhaps you meant…’ How do I write the input field expression so nulls and undefineds are simply ignored? Or is this a bug in CONCAT / Aggregate? Thanks in advance! (PS: I don’t think I want a string with back-to-back delimiters, e.g. “abc|xyz||aa||bb” if I can avoid it, but even that would be better than failing on error.) SolvedAggregate column next snap Hi Team, how i can pass not aggregate column next snap
