cancel
Showing results for 
Search instead for 
Did you mean: 

Fetching data from excel file

harsha_ganapathy
Participant
0 Kudos

Hi All,

I am trying to do fetch the data through excel file by providing path directory. when i selected the path as mentioned below. I was not able to see the file in that particular path.It was showing Desktop only. Please find the below screenshot for more details:

We  also see  'Import schema' is disabled, meaning its not fetching the data.Could you please give the reasons and solution for the above issue.

Thanks,

Harsha

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

You are using the substitution parameter for directory access. It will take the address on runtime only. If you want to import the schema at design time then select the file directory and file manually.

harsha_ganapathy
Participant
0 Kudos

Hi Shailesh,

I have tried to put the directory also like /DIR_HANA_USR/Inbound.Still it was not fetch the data for the particular path.

Former Member
0 Kudos

Hi,

Try to select the directory manually using select folder option.

or else use the directory address like that \DIR_HANA_USR\Inbound

Former Member
0 Kudos

Just type your file name manually there eg:. Filename.xls and try to import.

Normally Server will not access to fetch data from desktop. So I keep the files in share drive so that DS server would fetch without any permission issue.