Search found 12 matches

by indu
Wed Sep 21, 2011 10:51 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Convert Excel file to xml
Replies: 1
Views: 2166

Convert Excel file to xml

Hi, I have an input excel file which needs to be converted to an XML file. The xml output is of a specific format, which has additional columns of default value, other than columns in the input xls file and also column names which are different from the input xls file. I want to know how can we crea...
by indu
Tue Aug 02, 2011 10:13 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Return LookUp Value
Replies: 4
Views: 3321

Re: Return LookUp Value

Thanks Agata,
It worked with DBLookup :)
by indu
Wed Jul 27, 2011 10:26 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Return LookUp Value
Replies: 4
Views: 3321

Re: Return LookUp Value

Hi Agata, Tried to create a graph following your graph. The graph is running successfully but there are no outputs! The data source field seems to be empty in your graph. Is that the problem that i am not getting the output?? Also the Data Source tab takes FileURL, is there any way that i can connec...
by indu
Tue Jul 26, 2011 12:37 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Return LookUp Value
Replies: 4
Views: 3321

Return LookUp Value

Hi, I am trying to do a look up on a table (Product table, having columns Product_key,Product_code) using a code (say Product_code) coming from a input file. After the lookup i want to return the primary key(Product_key). Please tell me which component should i use. I tried using LookupJoin but i co...
by indu
Tue Jul 12, 2011 10:44 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Date Timestamp
Replies: 2
Views: 2800

Re: Date Timestamp

Thanks Agata. Didnt know that we could set the format in Metadata. It worked :)
by indu
Mon Jul 11, 2011 12:59 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Date Timestamp
Replies: 2
Views: 2800

Date Timestamp

Hi,
How can i insert system date with timestamp(2011-07-11 15:05:00) into Oracle DB.
In the Date Functions I see that there is today() function which returns only date(2011-07-11).

Thanks,
Indu
by indu
Mon Jul 11, 2011 10:28 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Atrribute Reformat
Replies: 3
Views: 2883

Re: Atrribute Reformat

Hi Jaro, I am trying to insert data from an Input file to the Initiate hub using Memput Component. In between this step i am using the Atrribute Reformat Component. i could see a warning on the Atrribute Reformat component saying WARN [main] - [INITIATE_REFORMAT0] - Attrrecno field does not exist in...
by indu
Mon Jul 11, 2011 8:00 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Atrribute Reformat
Replies: 3
Views: 2883

Atrribute Reformat

Hi, I am trying to add two new columns(Created_date & Lastupdated_date) to the existing data flow using the Atrribute Reformat Component. I want to know what needs to be populated for the Attribute code field in the Properties Menu. I tried to give both the Attribute code values of Created_date ...
by indu
Tue Jun 28, 2011 12:27 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Reading data from Initiate through Clover ETL
Replies: 6
Views: 3807

Re: Reading data from Initiate through Clover ETL

Yes i have tried including all the values in Memstatfilter. Nothing Works!
Anyways Thanks a lot for ur quick replies.
Appreciate it :)
by indu
Tue Jun 28, 2011 10:14 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Reading data from Initiate through Clover ETL
Replies: 6
Views: 3807

Re: Reading data from Initiate through Clover ETL

Hi Agata, I have not specified any value in the Member status filter(Memstatfilter) field. I also tried setting it to the below values. A: Active O: Overlay M: Merged D: Deleted Still getting the same error. Is there any other thing that i am missing out. Attached is the screen shot of my graph. Tha...
by indu
Tue Jun 28, 2011 8:24 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Reading data from Initiate through Clover ETL
Replies: 6
Views: 3807

Re: Reading data from Initiate through Clover ETL

Thanks for ur reply, I am trying to read data from the Initiate, i have used a data reader through which i am passing the MemRecno and trying to read data from Initiate using MemRecno as the key input and mapping attribute fields to output fields and writing the output fields to a file using univers...
by indu
Mon Jun 27, 2011 10:42 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Reading data from Initiate through Clover ETL
Replies: 6
Views: 3807

Reading data from Initiate through Clover ETL

Hi, Could u please help me on how to read data from Initiate through Clover ETL. I tried using Memget component, but i could'nt understand why is an input reader needed for memget component and how to configure the mapping(Key field and Input field). What are segment code filter and segment attribut...