No, it's the right component. They key is to write SQL with something AS colName
in the select list, so that the output column names match the column names the component needs. Drag a fresh component onto a window and examine the sample dataset it starts with. Arrange for your SQL binding to deliver the same column names and types.
4 Likes