You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2017-04-07 08:18:09

ViswanathaChalla
Member
8 posts

ViswanathaChalla said:

[resolved] insert file name and job_id to the columns in a target table

Hi,
My Requirement is i need to insert the File_name which i am loading and job_id into columns in the target table.

Any help how to do this is help full.

Thanks 
Viswanatha Challa 

Offline

#2 2017-04-07 08:53:29

TRF
Member
388 posts

TRF said:

Re: [resolved] insert file name and job_id to the columns in a target table

Hi,
My requirement is that you give us a little more detail.
Which component are do you use?

Regards,
TRF

Offline

#3 2017-04-07 10:24:22

ViswanathaChalla
Member
8 posts

ViswanathaChalla said:

Re: [resolved] insert file name and job_id to the columns in a target table

Hi,
I am loading data from one flat file (tFileInputDelimited_3) to Oracle Data base, where i have a file name column and i need to load the current file name into that column.
mini_blob_20170407-0226.png

Last edited by ViswanathaChalla (2017-04-07 10:26:56)

Offline

#4 2017-04-07 11:06:13

TRF
Member
388 posts

TRF said:

Re: [resolved] insert file name and job_id to the columns in a target table

Filename of tFileInputDelimited is not accessible from any global variable.

Use tFileList before to read the file, giving something like:
mini_blob_20170407-0255.png

tFileList:
mini_blob_20170407-0257.png

tFileInputDelimited:
mini_blob_20170407-0301.png

tMap:
mini_blob_20170407-0302.png

and finally, the result:
mini_blob_20170407-0305.png

Hope this helps.
TRF

Offline

#5 2017-04-07 11:13:31

ViswanathaChalla
Member
8 posts

ViswanathaChalla said:

Re: [resolved] insert file name and job_id to the columns in a target table

Thanks that works smile

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy