1.Create a any flat file with some data in it and save it as CSV

Flat File 0001.jpg
  
2.  Login to HANA Studio

  • Goto either FILE Import option  OR

    FF01.jpg

  • Select HANA Modeler Perspective and directly click on ‘Import’ option

   FF02.jpg

  • Goto ‘SAP HANA CONTENT’ folder and select -> ‘Data from local file’

FF03.jpg

3.Select HANA System

FF04.jpg                 

4.We will get Below screen :-Select the details as mentioned below.

  • Select File:- File path where the file is saved
  • Header row exists :- Number header row to be ignored
  • New Schema :-Schema name under which table has to be created
  • Table Name :-Name of the table

FF07.jpg

                                       

5.Click on ‘Next’ then we will get a screen like below. In this step already field mapping
would have made. If it is required to change the mapping we can click on the
‘ICON’ (FF08.jpg) which is highlighted.

FF10.jpg

  • We will get two options for mapping as shown below

FF11.jpg

6.Click on Finish. If this activity is success then we can view the job logs as shown below.

   FF12.jpg


7.Goto ‘Tables’ under your schema and refresh then we can see the table created

8.To view the content of the Table. Goto Table–>Context menu–>select Open Data Preview

FF13.jpg
8.We will get a screen like below.So,that we can view the content of table

FF16.jpg

To report this post you need to login first.

8 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply