MAPPING OF DATE

[sunil_sawargave]

Dear Community,

I want to Map "DATE" Column with the "MONTH" ,"DAY" , "YEAR" Column in the above table.

Here i want to Merge "MONTH" "DAY" " YEAR" Column in to One Column as "DATE1" then i want to map.

Thanks & regards

Sunil

[Vegar]

What do you mean by "MAP"?

I did not really understand  your DAY field, but if you can get it to contain the day number of the month (16 in your image) then you can get YEAR, MONTH, DAY into a Date1 field by using date#() like this:

Dayname(date#(YEAR & '-' MONTH &'-'&DAY, 'YYYY-MMM-DD' ))

[sunil_sawargave]

Hi, Thank you for your reply,

here "DAY " Field generated after unpivot table ,

here , 1) Excel Sheet there is two column "COST CENTER "  " SHOP NAME"

 2) Table  1 There are FOUR Column "COST CENTER" "DATE" "REASON CODE" & "SCRAP COST"

I have assoociate these excel sheet with Table one & doing left join apply on that & mapping with COST CENTER ok.

AFTER THAT there is another table Table2 , here i have to do unpivot table & Get the table as "SECTOR NAME", "SHOP NAME", "YEAR"  "MONTH" "DAY" & "DAY VALUE" . HERE "DAY" Column are generated after unpivot the table2.

Here i want to merge this Three column "YEAR","MONTH" "DAY"i nto one colimn as "DATE1 " 

Then i want to join excel sheet , table1  & table2 with mapping field "SHOP NAME" & "DATE1" with "DATE"

Hope you understand my requirement.

Thnak you 

sunil

[Mark_Little]

HI @sunil_sawargave 

As you want to bring across three fields i would just do a join instead of a map. 

Left Join ('Existing Table')

LOAD

DATE(MONTH&'/'&SUBFIELD(DAY,'_',2)&'/'&YEAR,'MM/DD/YYYY')  AS Date, 

DAY,

MONTH,

YEAR

FROM .....

//Use Date not Date1 as it wants the same name for the join 

[sunil_sawargave]

Hello Mark6505,

Thank you for your reply,

Here in the above table i want to just merge above three column which are "AT_EQ_VEHICLEMASTER_MONTHLY.Attribute", "MONTH_S" "FY_YEAR_S"  into on column as "DATE".

Following table is original table i have to unpivot this table generated the above table .

so i want to merge Above table three column into one column.

hope you understand it.

Thanks 

Sunil

HERE "AT_EQ_VEHICLEMASTER_MONTHLY.attribute" Column generated after unpivot the table field.

[sunil_sawargave]

Hello Community,

This is my original table in database,

I have to Add this above table AT_EQ_VEHICLEMASTER_MONTHLY from my Database.

As per my requirement, i have to Unpivot of the table in qlik sense with qualified field which i require then the following table generated.

So here I want to MERGE Three column  are " AT_EQ_VEHICLEMASTER_MONTHLY.Attribute " & "MONTH_S" & "YEAR_S"into one Column as"DATE".

Here "AT_EQ_VEHICLEMASTER_MONTHLY.Attribute Field" & "AT_EQ_VEHICLEMASTER_MONTHLY.Attribute Data" these two new column generated after perform unpivot operation on the table.

OUT PUT IS LIKE :

SHOP NAME	DATE	AT_EQ_VEHICLEMASTER_MONTHLY.Attrubute Date
12 JPH PAINT SHOP	8/1/2022 (MM/DD/YYYY)	0
12 JPH PAINT SHOP	8/1/2022 (MM/DD/YYYY)	13.8
12 JPH PAINT SHOP	8/1/2022 (MM/DD/YYYY)	0
12 JPH PAINT SHOP	8/1/2022 (MM/DD/YYYY)	13.8
12 JPH PAINT SHOP	8/1/2022 (MM/DD/YYYY)	11.2
12 JPH PAINT SHOP	8/1/2022 (MM/DD/YYYY)	55.5
12 JPH PAINT SHOP	8/1/2022 (MM/DD/YYYY)	552.85

THANK you

Sunil