When I run an Excel Module which contains SQL, the data going into the first Excel table is populated with 114,532 rows.
But the second Excel Table (which has a concat as part of the SQL) is populated with 256 blank rows. However, when I run the second SQL query straight in the db, it returns all 114,532 fully populated rows of data as a concat - why is Excel producing 256 blank rows when there are actually values?
The Forum wouldn't let me post the SQL in here - so please see attachment.
Bookmarks