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

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!