DSXchange

hi,

I'm using a Join stage with 4 sequential files as inputs. Using Inner Join on a dummy key(integer(1)). However, the job fails at runtime throwing the following error:

Non-aggregate component in select:dummy.col1

Col1 is an integer(1) nullable field from one of the files.

Kindly help...
Thanks.

Hi,

Are you sure about, dummy column is present in all four input sequential files and check the nullability of Dummy Col in all four input files. Nullability should be same in all 4 input columns.

The issue is resolved. The problem was with the Metadata...
Metadata was imported from a CFD and it had levels. On removing the levels it worked fine.
Thanks

Nageshsunkoji wrote:Hi,

Are you sure about, dummy column is present in all four input sequential files and check the nullability of Dummy Col in all four input files. Nullability should be same in all 4 input columns.