New to Qlik Sense

[sunil_sawargave]

Hello Community,

I Have Table With "SHOP NAME" || DAY|| MONTH|| YEAR|| "DAY VALUE" ||  These are Column, Here Second Column is generate when unpivot field.

Here I want to Create One column "DATE " From DAY ||MONTH|| YEAR  three Column. 

I am able to Merge MONTH & YEAR COLUMN But i am not able to merge these three column because i think there is DAY column is Unpivot column so i think.

so please guide me to merge thre column into one column.

Given my table

I want solution is like:

SHOP NAME	DATE	DAY VALUE
12 JPH PAINT SHOP	01/08/2022	0
12 JPH PAINT SHOP	02/08/2022	13.8
12 JPH PAINT SHOP	03/08/2022	0
12 JPH PAINT SHOP	04/08/2022	0

Thanks & regards

Sunil Sawargave

[brunobertels]

hi try this 

MakeDate('2022',num(month(date#('sept.','MMM'))),'22')

MakeDate(YEAR, num(month(date#(MONTH,'MMM'))), DAY)

[sunil_sawargave]

Thanks Brunobertels for your valuable reply,

I have to add this in new script , so its not showing any error but not working.

So where to add this one in script.

Load *,

MakeDate(YEAR,Num(Month(Date#(MONTH,'MMM'))),DAY) AS "DATE 1"

Thanks & regards

Sunil

[sunil_sawargave]

Hi ,

i have to add in autogenerated Script like belo but getting error .

Thanks & Regards

Sunil

[brunobertels]

Hi

try preceding load : 

MyTable :

Load *,

MakeDate(YEAR,Num(Month(Date#(MONTH,'MMM'))),DAY) AS "DATE 1" ; 

Crosstable( .....,4) 

load 

....

from ... 

[sunil_sawargave]

Hi,

Thank you but its not working,

I have to create new script & add but its getting error after load data,

Thanks & regards

Sunil