You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » regarding the usage of tDBSQLRows
#1 2007-03-28 07:29:59
- deepakkr
- New member
- Registered: 2007-03-28
- Posts: 5
regarding the usage of tDBSQLRows
hi,
i am new to the JasperETL tool, i have got a list of directory name in the table. i am trying to read a set of files from the directories. But i dont know how to give the name of the directory to tFileList component as input. If any body have tried this method, please let me. i have tried using the tDBSQLRows,but i dont know how to retrieve the value from the component tDBSQLRows as input to tFileList.
regards,
deepak
Offline
#2 2007-03-28 17:46:35
Re: regarding the usage of tDBSQLRows
I've used TOS 2.0.0M3 to design the job example.
The "trick" is in the tFileList, where I use fill the "Directory" property with:
Code:
$tMysqlInput_1[0]
Code:
[pierrick@plegall] ~/temp/200703/20070328/topic443
$ tree
.
|-- 01
| |-- a.txt
| `-- b.txt
`-- 02
`-- a.txt
2 directories, 3 files
[pierrick@plegall] ~/temp/200703/20070328/topic443
$ mysql --user=root --password=conway talend
mysql> select * from topic443;
+-------------------------------------------------+
| dirname |
+-------------------------------------------------+
| /home/pierrick/temp/200703/20070328/topic443/01 |
| /home/pierrick/temp/200703/20070328/topic443/02 |
+-------------------------------------------------+
2 rows in set (0.00 sec)The job output is:
Code:
Starting job topic443 at 17:38 28/03/2007. /home/pierrick/temp/200703/20070328/topic443/01/a.txt a|b|c|d e|f|g|h /home/pierrick/temp/200703/20070328/topic443/01/b.txt i|j|k|l m|n|o|p /home/pierrick/temp/200703/20070328/topic443/02/a.txt q|r|s|t u|v|w|x Job topic443 ended at 17:38 28/03/2007. [exit code=0]
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » regarding the usage of tDBSQLRows