topic Re: Missing date not retrieve in Talend Studio

Missing date not retrieve

Anonymous — Sat, 22 Feb 2020 18:11:05 GMT

Vipin_vipz:
Hello guys
I am new to this tool.... I'm facing an issue i have two excel file..... I have to insert missing values of a coloumn from one file to 2nd one having reference column in both files

what should be right approach to fix this issue.

Appreciate if any one of you please guide.

Thanks

Re: Missing date not retrieve

Anonymous — Mon, 24 Feb 2020 03:36:24 GMT

Hi
Please show us some example data to explain your requirement, so that we can give your more accurate answer .

Regards
Shong

Re: Missing date not retrieve

Anonymous — Mon, 24 Feb 2020 04:42:56 GMT

I have these two xlsx file. In collection input file there are two columns Bill_No and Manual_PRNo in which some data are missing so i have to retrieve those missing data with the help of INPUT named file where all data are present.
Collection Input Format.xls

Re: Missing date not retrieve

Anonymous — Mon, 24 Feb 2020 06:36:45 GMT

Hi
I think you need to do an inner join between two file to retrieve the missing data based on the key columns, please refer to this article
https://community.talend.com/t5/Design-and-Development/Doing-an-inner-join-using-a-tMap-component/ta-p/21572

Take a look at it and learn the scenario, let me know if you still have any questions.

Regards
Shong

Re: Missing date not retrieve

Anonymous — Mon, 24 Feb 2020 06:59:28 GMT

i've already applied this concept of matched and unmatched in output. But it did not retrived missing data of columns in file "collectioninput" from file input.

Do we need any filter expression in output?

Re: Missing date not retrieve

Anonymous — Mon, 24 Feb 2020 07:20:40 GMT

Please share some screenshots of your job or upload the job, so we can know what you are doing wrong and help you.

Re: Missing date not retrieve

manodwhb — Mon, 24 Feb 2020 13:26:16 GMT

@nsingh , you can do with tmap and do the inner join and missing file is main and other file is lookup and in the output section of tmap activate filter with that the column have null values.