Creating lines per (Year&Month) in load

[hschultz]

Hi all

I hope that someone is able to assist me.

I have a table with some detail including Start & End dates.

Basically what i want to do is create a colum that i can use as a link to another table. This colum needs to have the Dimension&Year&Month for the link. Here is an example of what i'm talking about.

This is the data

Customer	Start Date	End Date	"Other Detail"
AAA	2012/01/01	2012/03/31	*Colums of data
BBB	2012/02/01	2012/04/30	*Colums of data

This is what the result is supposed to be:

Customer	Start Date	End Date	"Other Detail"	LINK Created
AAA	2012/01/01	2012/03/31	*Colums of data	AAA|2012|JAN
AAA	2012/01/01	2012/03/31	*Colums of data	AAA|2012|FEB
AAA	2012/01/01	2012/03/31	*Colums of data	AAA|2012|MAR
BBB	2012/02/01	2012/04/30	*Colums of data	BBB|2012|FEB
BBB	2012/02/01	2012/04/30	*Colums of data	BBB|2012|MAR
BBB	2012/02/01	2012/04/30	*Colums of data	BBB|2012|APR

So basically the data will be duplicated for as many months as the date makes it be active.

Thank you for the assistance

[#2]

Hi,

If you want to show 'LINK created' column in the chart then you can simply add an expression:

Customer & '|' & Year(Date field) & '|' & Month(Date field)

If you want to create a key to join these tables in data model then you have to define same expression in the script.

Hope this helps.

Regards,

Neha Rangari

[hschultz]

It is not for a chart unfortunately. I need this in order to link to another table in my LOAD script

[#4]

Could you please share tablenames & fieldnames from the script?

[hschultz]

Sorry, but I don't understand what you need.

It's basically as i have stated there in the first post. Only with a few more colums.

[hschultz · Accepted solution]

Here is the answer to my requirement