convert the unix timestamp

[Anonymous]

Hello,
I  want to convert the unix timestamp  1443696342801  into date ,
i am new to Talend , i converted  1298226724 into date using  below logic , please see below attach screen shots:

But i am unable to convert this number 1443696342801  
any suggestion will be helpfull
its little urgent 
thanks
Amit

[Anonymous]

Hi Sabrina
Thans for your suggestion , I have implemented it and its working fine
I am facing another problem now i.e. I want to apply the particular kind of logic on multiple columns present in source I am have already created a job like this
What I want is to repeat the process for multiple columns as follows
can you please guide me regarding this....
waiting for reply

[Anonymous]

Hi All,
1 general Question,
What we can do at data warehouse side when we need to delete bunch of records.?
or for which things we should take care about before start delete records from data warehouse?
Except Backup, is one of them. 
- What are Best Practice ?
- Operations on DWH before start delete?

[Anonymous]

Hi Everybody,
I need help from you,
I am trying to implement an ETL job. I have REMARK column in target table which holds remarks for every column if that particular column failed at validation. 
Ex -  Suppose that I Have ID column in source (Excel), it should hold only Numeric values but in case if it contains any character then that particular record should go under error table and Remark column hold remark that"ID should be Numeric."
Like wise, i need to implement it for multiple columns & REMARK column should be updated for every column if they all got failed at validation.
  like Date Fields- Start_Date Should be less than End_Date.
Description Field - Should contain only 1000 characters max to max.
Any Required (*) field should not be null.
Boolean fields contain only TRUE & FALSE in capital form , should not contain any 'Yes', 'No',123 or nul
 
Waiting for positive reply..

[Anonymous]

Hi Sabrina.. How are you?

[Anonymous]

Hi All, 

I have done it after all, Please see image attached here and solution for it as follows-
1)Sort out data on the basis of EXPECTED & REJECTED records through your business rule like NAME should not be null if it is null then it should go under ERROR table. After that take 1 variable and put this logic - Source.triNameTX==null?"(triNameTX Should not be Null)":"" and use this variable in REMARK column of ERROR table.
2)START date should less that END date - Var2- (Source.triSTARTDA != null && (Source.triSTARTDA.before(Source.triENDDA))) || 
Source.triSTARTDA == null  (Boolean Type)
Var3 -(Source.triSTARTDA!= null && (Source.triSTARTDA.after(Source.triENDDA)))||Source.triSTARTDA == null?"(triSTARTDA Should'nt be NUll or Less than triENDDA)":"" 
3) Now, Concatenate Var.var1+Var.var2 and run your job & after completion of your job take look into REMARK column , you will see -(triNameTX Should not be Null)(triSTARTDA Should'nt be NUll or Less than triENDDA).
so like wise you can do it for many columns as per your Business Rule.

       
Rejected Output File..

[SJeshwani1618330394]

Hi,

I resolved to convert epoch time but it's giving me 1985-11-15 01:00:00 instead of 1985-11-15 00:00:00. The only difference is the hours.

It would be great if you can help me 🙂

Regards,

Sheetal

[Anonymous]

Hello,

Could you please let us know which value you are working with?

Is it in milliseconds?

You can use below mentioned function directly in tMap

(row1.epochtime == null || row1.epochtime =="") ? null : (new java.util.Date(Long.parseLong(row1.epochtime) * 1000) );

Please give us some Epoch time examples.

Best regards

Sabrina

[SJeshwani1618330394]

Hi Sabrina,

Thank you for your reply.

The epoch value I am working on is: 500860800000

I tried to use "yyyy-MM-dd HH:mm:ss.SSS" but it's still not working.

I used the function you have mentioned, but I am getting an error.

Thanks,

Sheetal

[Anonymous]

Hello,

What's error are you getting? Are you still having trouble in "hours" for your case?

Best regards

Sabrina