Issue with Date

[#1]

Hi All, I have an excel file containing attendance records of all employees in the format specified below.

Employee #	Names	Team Name	Designation	Work status	01-Jan-16 Fri	02-Jan-16 Sat	03-Jan-16 Sun	04-Jan-16 Mon	05-Jan-16 Tue	06-Jan-16 Wed	07-Jan-16 Thu
1	Priya	IT	Analyst	Active	P	P	P	P	P	P	P
2	Priyanka	IT	Analyst	Active	A	A	A	A	P	P	P
3	Monika	Finance	Analyst	Active	P	P	P	P	P	P	P
4	Sarvesh	Admin	Analyst	Active	P	P	P	P	P	P	P

And I want it to load it in below format

Employee #	Names	Team Name	Designation	Work status	Date	Att_Value
1	Priya	IT	Analyst	Active	01/01/2016	P
2	Priyanka	IT	Analyst	Active	01/01/2016	A
3	Monika	Finance	Analyst	Active	01/01/2016	P
4	Sarvesh	Admin	Analyst	Active	01/01/2016	P
1	Priya	IT	Analyst	Active	02/01/2016	P
2	Priyanka	IT	Analyst	Active	02/01/2016	A
3	Monika	Finance	Analyst	Active	02/01/2016	P
4	Sarvesh	Admin	Analyst	Active	02/01/2016	P
1	Priya	IT	Analyst	Active	03/01/2016	P
2	Priyanka	IT	Analyst	Active	03/01/2016	A
3	Monika	Finance	Analyst	Active	03/01/2016	P
4	Sarvesh	Admin	Analyst	Active	03/01/2016	P
1	Priya	IT	Analyst	Active	04/01/2016	P
2	Priyanka	IT	Analyst	Active	04/01/2016	A
3	Monika	Finance	Analyst	Active	04/01/2016	P
4	Sarvesh	Admin	Analyst	Active	04/01/2016	P
1	Priya	IT	Analyst	Active	05/01/2016	P
2	Priyanka	IT	Analyst	Active	05/01/2016	P
3	Monika	Finance	Analyst	Active	05/01/2016	P
4	Sarvesh	Admin	Analyst	Active	05/01/2016	P
1	Priya	IT	Analyst	Active	06/01/2016	P
2	Priyanka	IT	Analyst	Active	06/01/2016	P
3	Monika	Finance	Analyst	Active	06/01/2016	P
4	Sarvesh	Admin	Analyst	Active	06/01/2016	P
1	Priya	IT	Analyst	Active	07/01/2016	P
2	Priyanka	IT	Analyst	Active	07/01/2016	P
3	Monika	Finance	Analyst	Active	07/01/2016	P
4	Sarvesh	Admin	Analyst	Active	07/01/2016	P

But the issue I am facing is with the date column. It is getting loaded in number format. I tried converting it into date format using date and date# function but couldn't achieve desired result.

I need your suggestions.

Thanks in advance

-Priyanka

[ajsjoshua]

Hi,

while loading the excel after clicking the Embedded labels click Cross Table

and enter the Qualifier fields ,attribute fields and data field.

[sasikanth]

For the desired format use CrosTable load

Cross Table(Date,Att_value,5)

Load * from Excel;

Please attach sample data

[tresesco]

Using Crosstable(), you could get that. Try to share a sample excel which we can work upon.

[#5]

Tresesco - I am not getting option to attach sample file.

[tresesco]

Click on Reply-> Use advanced editor (top right) ->Attach (bottom right)

[#7]

Hi,

I am not getting Attach option.please see below screenshot.

[tamilarasu]

Hi,

Check the attachment.

Edit: Sorry, Missed to change the date format. Attached new file against your data.

[tresesco]

It seems the option is not somehow not appearing for you. You might have to contact community admin CommunityAdmin‌ or sli‌

[Chanty4u]

u can open ur discussion in seperate tab then only u will find right side top advnced editor

right bottom u will ffind attach