topic Re: how to join two tables by using different date fields? in QlikView

how to join two tables by using different date fields?

Thu, 20 Jun 2013 06:26:25 GMT

Hi,

I have two tables

one is sales and date table now i want to join two tables by using fiscal year filed

Sales table Date Table

Fiicsalyear Fiicsalyear

Fy01 2001

Fy02 2002

Fy03 2003

i used

'FY'& mid(Fiscalyear,3,2) as Fiscal_Year for chaganging date table filed to joing with sales table

but it giving script execution faield error

please help me

if there any other date formats are needed

Thu, 20 Jun 2013 06:28:56 GMT

It look like ok..

Check spelling of fields..

If you still facing problem then please paste your coding here for futher reference

Thu, 20 Jun 2013 06:41:16 GMT

difference in spelling of

Fiicsalyear and mid(Fiscalyear,3,2)

try this code

SalesTable:

load Fiicsalyear as Fiscal_Year;

LOAD * INLINE [

Fiicsalyear

Fy01

Fy02

Fy03

];

DateTable:

load * ,'Fy'& mid(Fiicsalyear,3,2) as Fiscal_Year inline [

Fiicsalyear

2001

2002

2003

];

Thu, 20 Jun 2013 06:59:13 GMT

Spelling is not a iisue

the both table date formats are diifferent thats why the join condition is not working

Thu, 20 Jun 2013 06:59:45 GMT

Spelling is not a iisue

the both table date formats are diifferent thats why the join condition is not working