topic date dimension in Talend Studio

date dimension

Anonymous — Sat, 08 Feb 2020 16:28:32 GMT

need to generate a date dimension table. what is the function to generate the week based on the date and not the day?

Eg. If 31st dec is a Wednesday, it should be week 52, and Jan 1st should be week 1.

Thank you!

akumar2301 — Sat, 08 Feb 2020 16:53:43 GMT

http://diethardsteiner.blogspot.com/2012/02/talend-open-studio-populating-date.html?m=1

Above an example of date dimension. Function used changed to latest version. E.g.

int weekOfYear = TalendDate.getPartOfDate("WEEK_OF_YEAR",date);

Anonymous — Sat, 08 Feb 2020 17:02:27 GMT

it is giving us the date of the year. we want to extract week of the month.

like from 23rd to 29th of feb should be week 4 of feb

1st march to 7th march should be week 1 of march

how to resolve this?

Thanks a lot

akumar2301 — Sat, 08 Feb 2020 17:26:34 GMT

Try

TalendDate.getPartOfDate("WEEK_OF_MONTH", row1.date)