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-03 15:59:11

Colleen
Member
37 posts

Colleen said:

How to do this in Talend?

Hi,
I have a csv which has more than 30 columns and there are three columns that are of utmost importance. The columns are Address, Cancelled and Can Week End.
                 Address                                        Cancelled                                             Can Week End
 1         1234 Java Street                                 TRUE                                                   3/12/2017
 2         5617 Talend Developer Road                 FALSE (should be TRUE)                         Null (should be 4/2/2017)
 3         6587 Integration Court                         TRUE                                                   3/19/2017
 4         1234 Java Street                                TRUE                                                   3/26/2017
 5         7458 Null Creek Road                          FALSE  (should be TRUE)                        Null (should be 4/2/2017)
 6         5617 Talend Developer Road                FALSE                                                  Null
 7         7458 Null Creek Road                          FALSE                                                 Null
 8         6587 Integration Court                         FALSE                                                 Null
 9         1234 Java Street                                 FALSE                                                 Null

An address can be cancelled in multitude. 

No address can be written twice unless the previous time the address was written was cancelled and the Cancelled column depicts TRUE and week ending (Sunday Date) of the passed week. The users of the csv unknowingly make mistakes and then it is up to us to fix this before it lands in the database. Rows number 1, 3 and 4 are ideal but the rows 2 and 5 is what I am requesting assistance with.
mini_Capture_20170403-0754.png
This is my job. What can I add in tMap or some other component that would change the FALSE value to TRUE if Talend sees the same address second time or third time or fourth time without the previous time it was cancelled does not show TRUE. And when Talend sees the Address change it to TRUE and write down the week ending Date (passed Sunday) date under the Can Week End.
Please provide insights.
Thanks in Advance,
CM

Last edited by Colleen (2017-04-03 16:00:35)

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy