-
DML for excel csv source
I am a newbie to Abinitio Technology and i want to know how an excel/csv (source file) can be chose as input/source file for the input file component. How can we write a DML for the same if the source file column has variable length.
Thanks and appreciate help and guidelines from you all for my learnings.
-
Junior Member
Re: DML for excel csv source
Hi
For ur query, we can use delimeter
example,
record
decimal(',') custid;
string('\r\n') custname;
end
-
Junior Member
Re: DML for excel csv source
Hi,
I am giving good example to understand the delemeter.
In Ab Initio Log flows also has variable lenth.
Logging flows have predefined metadata.
The log port record format is:
record
string("|") node;
string("|") timestamp;
string("|") component;
string("|") subcomponent;
string("|") event_type;
string("|\n") event_text;
end
Regards
Raja
Together. Free your energies
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules