Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
borrisbeck
Contributor
Contributor

Pass data from tmap as stream output to tFileoutputPositional

I'm trying to create a generic job to load fixed width files, But sometimes the files may contain additional characters, in that case, that record needs to be rejected, I have designed a job, where I'm passing the file metadata to "tSetDynamicSchema" and table metadata by context parameters.

In order to get the length of the records to check for additional characters, there is no direct way to get it from tFileinputpositional, So I used tFileInputFullRow to read the whole record and filtered out records with additional characters using tmap. Now I want to pass the dynamic column output from tmap as streamoutput to tFileoutputpositional.

Any idea how can I get the output from tmap and pass it to tFileoutputpositional as streamoutput?, so that it can be loaded into the oracle table.

I have marked that section in blue.

0693p00000BYLT3AAP.jpg

Labels (2)
1 Reply
manodwhb
Champion II
Champion II

@maximus jack​ ,check the below link.

 

 

https://help.talend.com/r/qv1pRZZ~V2OH8sAgI2gmvQ/cGB0fvqBFWGCOLgBcpmCww

you need to use below way.

 

 

((java.io.OutputStream)globalMap.get("tDropboxPut_1_OUTPUTSTREAM"))

 

Thanks,

Manohar