Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm using TOS for Data Integration 5.4.1.
Objective : Creating metadata schema for one time and reading the csv files using metadata without specifying the schema on the fly.
Here i have created metadata for csv file and saved it. So fro other files with the same structure i can use the same metadata while reading the file using tFileInputDelimited(by selecting type as repository) , which works fine .
But facing issues while dealing with a set of csv files with the same field structure . Here i have created a job which reads csv files using tFileList.In next step when i use tFileInputDelimited to read the files , have selected the metadata by choosing type as repository. In FileName/Stream it shows the file which is given while creating the metadata.
So there i wanted to use " ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH")) " kind of thing. But if i click on the fileName it doesan't allow me to do so.
So in this what can be done to achieve this.
I have attached the screenshot of the job.
I'm using TOS for Data Integration 5.4.1.
Objective : Creating metadata schema for one time and reading the csv files using metadata without specifying the schema on the fly.
Here i have created metadata for csv file and saved it. So fro other files with the same structure i can use the same metadata while reading the file using tFileInputDelimited(by selecting type as repository) , which works fine .
But facing issues while dealing with a set of csv files with the same field structure . Here i have created a job which reads csv files using tFileList.In next step when i use tFileInputDelimited to read the files , have selected the metadata by choosing type as repository. In FileName/Stream it shows the file which is given while creating the metadata.
So there i wanted to use " ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH")) " kind of thing. But if i click on the fileName it doesan't allow me to do so.
So in this what can be done to achieve this.
I have attached the screenshot of the job.
Hi,
My 1st paragraph says , i have created a job with the components
tFileList >> tFileInputDelimited >> tLogrow
Here i have used built-in schema where I'm creating the schema on the fly.Here in tFileInputDelimited i'm able to specify the file by giving "((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))".
By i do not wanted to create the schema on the fly .So i have created one more job with the components
tFileList >> tFileInputDelimited >> tLogRow
Here i created the metadata schema for FileDelimited and used in tFileInputDelimited by choosing Repository schema option. But if i do this, it gives me the file already choosen while creating the FileDelimited metadata. But i wanted this to change to "((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))"> so that i read the corresponding input file and disply the result.
Also i'm not looking for dynamic metadata creation in talend.
I have attached the screen shot .
Thanks,
ShreeCS
My 1st paragraph says , i have created a job with the components
tFileList >> tFileInputDelimited >> tLogrow
Here i have used built-in schema where I'm creating the schema on the fly.Here in tFileInputDelimited i'm able to specify the file by giving "((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))".
By i do not wanted to create the schema on the fly .So i have created one more job with the components
tFileList >> tFileInputDelimited >> tLogRow
Here i created the metadata schema for FileDelimited and used in tFileInputDelimited by choosing Repository schema option. But if i do this, it gives me the file already choosen while creating the FileDelimited metadata. But i wanted this to change to "((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))"> so that i read the corresponding input file and disply the result.
Also i'm not looking for dynamic metadata creation in talend.
I have attached the screen shot .
Thanks,
ShreeCS
check in screenshot, how it is implemented.
