Error when doing Append Query in dataflow

[Anonymous]

Hello All

Has anyone come across the following issue when doing an Append Query in dataflow -

Both my entities have exactly same number of columns.

Regards

[GilbertQ]

Hi there

It would appear that your entity is returning a LIST and not a table.

In the ribbon, click on the button that says "Convert to table"

[Anonymous]

@GilbertQ 

Actually, this was happening because my query was not pulling the preview data yet, so it was not allowing the append.

I tried it later after it pulled the complete preview data and then tried Append. It worked fine.

Regards