topic Re: Whether it is possible to create calendar table using tRowGenerator in Talend Studio

Whether it is possible to create calendar table using tRowGenerator

RAJ6 — Wed, 26 Jul 2017 07:25:20 GMT

Hi Talend Folks,

I need to create below structure calendar table using tRowGenerator component.

Whether it is possible or not?

Calendar Table :

Date Key (8 digit Numeric)

Cal Date (Date Format) (eg. 8JUNE2017)

Year (eg 2017)

Fiscal Year (eg.2017)

Month (eg. June)

Cal Month Num (eg. 6)

Cal Week Start Date (eg. 5JUNE2017)

Cal Week End Date (eg. 10JUNE2017)

Week (1 to 52) (eg. W1)

Cal Week Num (within Month) (eg. W1- W5 and resets to W1 with start for new month)

Day Name (eg. Thursday)

QTR Num (eg. Q2)

QTR Start Date (eg. 01APR2017)

QTR End Date (eg.30JUN2017)

Re: Whether it is possible to create calendar table using tRowGenerator

Anonymous — Wed, 26 Jul 2017 19:57:15 GMT

Hi,

You can use a tRowGenerator to generate a list of dates of your choosing, then use a tMap to create all the derived fields from that date.

I'm using context to define the start date (Date type) and number of days to generate. Then generating a sequence and adding that to the date for each generated row.

Then in your tMap, just calculate the rest as needed:

Re: Whether it is possible to create calendar table using tRowGenerator

RAJ6 — Thu, 27 Jul 2017 07:13:05 GMT

Thank you @lli

I appreciate for your response.I also completed 8 columns. completed columns are given in screenshots.

could please tell me?. How to create below column also?
1) Fiscal Year (2016-2017)
2) Cal Week Start Date (eg. 5JUNE2017)
3) Cal Week End Date (eg. 10JUNE2017)
4) Cal Week Num (within Month) (eg. W1- W5 and resets to W1 with start for new month)
5) Quarter Start Date (eg. 01APR2017)
6) Quarter End Date (eg.30JUN2017)
7) Fiscal Month
😎 Fiscal QTR

Re: Whether it is possible to create calendar table using tRowGenerator

cterenzi — Thu, 27 Jul 2017 13:51:01 GMT

You'll need to do date math. It may be easiest to create some routines to do the calculations. Stackoverflow has articles on how to calculate various dates based on a Java date.

Re: Whether it is possible to create calendar table using tRowGenerator

Anonymous — Mon, 03 Feb 2020 02:20:13 GMT

getting the error "cannot convert Date to String"

Re: Whether it is possible to create calendar table using tRowGenerator

Anonymous — Mon, 03 Feb 2020 04:59:55 GMT

@verma_gauri, check the data type of column, the data type should match the data type of return value of the function.