Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
How to import from multiple files in parallel, use the wildcard characters — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to import from multiple files in parallel, use the wildcard characters

Question
10
Views
0
Comments
edited Jan 16, 2020 11:34AM in Essbase

Content

Essbase 11.1.2.4

I want to import several files over maxl. Example in docs

import database Sample.Basic
data from local data_file '/nfshome/data/foo*.txt'
using local rules_file '/nfshome/data/foo.rul'
on error abort;

 

I tried different approaches but with no success

import database Task.db data
              from local data_file "c:\\Hyperion\\datafiles\\loadFILE??????????.txt"
                 on error append to "c:\\Hyperion\\datafiles\\dataloadTASK.err";

import database Task.db data
              from local data_file 'c:\Hyperion\datafiles\loadFILE??????????.txt'
                 on error append to 'c:\Hyperion\datafiles\dataloadTASK.err';

import database Task.db data
              from local data_file "c:\\Hyperion\\datafiles\\loadFILE*.txt"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!