Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sunil_sawargave
Contributor III
Contributor III

MERGE DAY-MONTH-YEAR COLUMN INTO ONE COLUMN As "DATE"

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

sunil_sawargave_0-1664878910148.png

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

 

 

Labels (2)
5 Replies
brunobertels
Master
Master

hi try this 

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

 

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

sunil_sawargave
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

Hi ,

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

 

 

sunil_sawargave_0-1664882815791.png

 

 

sunil_sawargave_1-1664882902816.png

Thanks & Regards

Sunil

brunobertels
Master
Master

Hi

try preceding load : 

MyTable :

Load *,

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

Crosstable( .....,4) 

load 

....

from ... 

 

 

 

 

 

sunil_sawargave
Contributor III
Contributor III
Author

Hi,

Thank you but its not working,

sunil_sawargave_1-1665030230294.png

 

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

sunil_sawargave_2-1665030306430.png

 

Thanks & regards

Sunil