Data Extract from QVW file

[akpofureenughwu]

Hello,

I currently working on a dashboard and I am extracting data from an existing file.

I successfully extracted the data but I need to manipulate the field (to produce date fields like Month, Year)

I need tips on how to do this

Please see attachments for clarity..

Best Regards

Akpofure

[sunny_talwar]

I guess create a Master Calendar which links to your field you want it to link to.

[maheshkuttappa]

Calender

Load

<Date.Filed Name> As date

Month(<Date.Filed Name>) as Month

MonthName<Date.Filed Name> ) as MonthName

Year(<Date.Filed Name> ) as Year.

resident <tableName

[Anonymous]

You could add a new Mater Calendar table Creating A Master Calendar‌in your and join that to the date field from your binary load.

[maheshkuttappa]

Calender

Load

Date.Filed Name

<Date.Filed Name> As date

Month(<Date.Filed Name>) as Month

MonthName<Date.Filed Name> ) as MonthName

Year(<Date.Filed Name> ) as Year.

resident <tableName>

[akpofureenughwu]

Thanks Sunny for your quick response and good suggestions.

Can you help me with tips on how to achieve that..

I tried introducing scripts after the binary statement.

It doesn't response...

[sunny_talwar]

Can you share the script you have tried?

[akpofureenughwu]

Thanks M. Kumar

Please I try this script you suggest, It didn;t load..

Please find attached file....

Maybe I didn't arrange the syntax well...

The table name is the one I will give to the qvw file.

[akpofureenughwu]

Please find attachment

[maheshkuttappa]

Few things are not right

Remove  "Calender: " Before Binary  load ( Please read the concept of binary load and its limitation)

Then below script

Load

CH.DOC.LAST_CHANGED_AT

CH.DOC.LAST_CHANGED_AT As date,

Month(CH.DOC.LAST_CHANGED_AT) as Month,

MonthName(CH.DOC.LAST_CHANGED_AT) as MonthName,

Year(CH.DOC.LAST_CHANGED_AT) as Year,

resident "Name of the table in which field CH.DOC.LAST_CHANGED_AT is present after binary load "

As Sunny and Bill suggested  Master calendar is way to go..