topic Re: month year format in QlikView

month year format

Anonymous — Wed, 28 Feb 2018 07:00:04 GMT

i have a master table which has

yearmonth as 201612

and another table yearmonth as dec 2016

need to join the to tables on id and this monthyear flag

but both date are in different format (they are string values)

how to convert and den join these two tables.

Re: month year format

kaushiknsolanki — Wed, 28 Feb 2018 07:07:15 GMT

Try below functions to convert them into date.

1. Date(Date#(yearmonth,'YYYYMM')) as NewyearMonth

2. Date(Date#(OtherDate,'MMM YYYY')) as NewOtherDate

Now you can use this fields to link each other.

Regards,

Kaushik Solanki

Re: month year format

Anonymous — Wed, 28 Feb 2018 07:13:25 GMT

its in string format so this function doesn't work directly

Re: month year format

vineetadahiya12 — Wed, 28 Feb 2018 07:18:27 GMT

Hi, Try the below code. This may help in converting the yearmonth format from 201612 to Dec 2016

Date1:

Load * inline [

Date_1

201612

201601

201602];

Date2:

Load * Inline [

Date_2

Dec 2016

Feb 2016

Jan 2016];

--------format date from Date1 alongwith your other column

load Date(Date#(Date_1,'YYYYMM'),'MMM YYYY')

Resident Date1;

Re: month year format

vineetadahiya12 — Wed, 28 Feb 2018 08:26:45 GMT

Try this - this will convert Dec 2016 to 201612

this may be helpful as well

Date(Date#(Date_2,'MMM YYYY'),'YYYYMM')

Re: month year format

Anonymous — Wed, 28 Feb 2018 13:03:34 GMT

so shud I do a left join

or just load table,beacuse it will hve synthetic keys two common columns are there

how to approach for this data model

Re: month year format

Anonymous — Thu, 01 Mar 2018 05:41:48 GMT

kndly help