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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] how to merge two files and get one output

i have this sinple job of transfering a data from csv to db table.
all i want is to check the rejected records and merge them into one file.
the tfileinputdelimited will reject some data due to schema validation.
and the touputmssql will also reject some records due to constraints.
all i want is to merge the rejected records in one single file.
i tried tfilelist-didnt work,
tcreatetemporaryfile too..didnt got the expected result.
help me in this matter, plz find the attached screenshot of my job for better undrstanding of the problem
thnks in advance
0683p000009MEQL.jpg
Labels (2)
13 Replies
Anonymous
Not applicable
Author

Hello,

A "Circle" in work flow is not allowed in talend.
Could you please have a look at document about:https://community.talend.com/t5/Design-and-Development/Can-I-create-a-Job-with-multiple-paths-from-a...

Best regards

Sabrina

cterenzi
Specialist
Specialist

In the tHashOutput_2 settings, check the "Link with a tHashOutput" box and choose tHashOutput_1 from the dropdown.

Start a new subjob with a tHashInput, link the tHashInput to tHashOutput_1 in the same manner as above. Specify the same schema in tHashInput that you used in your tHashOutput components. Connect the tHashInput to the output component of your choice.

Link the subjobs by creating an OnSubjobOk link between tFileInputDelimited_1 and tHashInput_1
Anonymous
Not applicable
Author

Hi,

You can't use tUnite to combine the output from a same tMap. Hence your facing this issue.

Anonymous
Not applicable
Author

This is very easy task and you have to make sure that each file must have one common column to merge in a single file.

I have created a demo video to solve this issue and you can watch it on YouTube by using below link-

https://youtu.be/rL_iDkZIPmQ