Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
while loading the excel after clicking the Embedded labels click Cross Table
and enter the Qualifier fields ,attribute fields and data field.
For the desired format use CrosTable load
Cross Table(Date,Att_value,5)
Load * from Excel;
Please attach sample data
Using Crosstable(), you could get that. Try to share a sample excel which we can work upon.
Tresesco - I am not getting option to attach sample file.
Click on Reply-> Use advanced editor (top right) ->Attach (bottom right)
Hi,
I am not getting Attach option.please see below screenshot.
Hi,
Check the attachment.
Edit: Sorry, Missed to change the date format. Attached new file against your data.
It seems the option is not somehow not appearing for you. You might have to contact community admin CommunityAdmin or sli
u can open ur discussion in seperate tab then only u will find right side top advnced editor
right bottom u will ffind attach