how to map field

[#1]

I have a Inline Table like this

Invoicetable:

LOAD * Inline [

Customer, Invoice Amount , InvoiceDate

Customer A, 1200 , 3/12/2012

Customer B, 1100 , 5/30/2013

Customer C, 1400 ,10/27/2012

Customer D, 1150 ,12/12/2014

];

and i have a FiscalCalender .

I need to map the InvoiceDate column of InvoiceTable with Year (column name) of Fiscal Calender .

So please suggest me , how do i go .

Thanks .

[sunny_talwar]

May be create a Fiscal Year calendar: Fiscal and Standard Calendar generation

[engishfaque]

Dear Gautam,

Please go through listed below link,

Don't join - use Applymap instead

http://www.learnqlickview.com/applymap-function-in-qlikview/

Kind regards,

Ishfaque Ahmed