Skip to Content
0

How to export data from HANA table along with Column Header/Column Name

May 08, 2017 at 06:11 AM

804

avatar image
Former Member

Hello All,

I am trying to export data from HANA Table to excel CSV format. Data is exported but column headers aren't coming.

Note : Exported data manually using mouse clicks and also using export SQL function.

Please let me know how do I handle this. When I export data it should be exported along with column header data.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member May 08, 2017 at 10:46 AM
0

Hello Sami,

please select the table right click on it & select open content,

select one of the record & click on insert query, it will pop up insert statement, close it.

again go back to content page & click on one of the record & click export result, save it

and open in a note pad.

Thanks & Regards,

Phani Kishore Akella

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Phani,

Thanks for your reply.

Actually I had performed this activity prior to my post. This is a manually activity after seeing the content of a table.

But my requirement is to get the results with column header. When you do a direct export on table or by SQL export function.

Please suggest me if we can achieve this. Or does this differ from support pack as Currently I am using SP9.

Thanks,

Sami

0