Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
May 6, 2022
@Catalin Bombea, thank you, your solution provided works, just that there is a challenge to sort the date in descending order, so that a student name will take the latest record for a given Name and Year but retain the same GUID.
Example: from the excel file, in the accreditation sheet tab, a student like Morgan whose record appears twice, maintains the same GUID across different years and classes while taking the latest record.How do i achieve that?
Thank you.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
May 6, 2022
@Catalin Bombea, i tried, sorting the column YEAR in DESCENDING ORDER AND WRA
ING IT WITH Table.Bufer(),However, what i get is the Guid id changing, instead of maintaining same GUID id number, and the latest year or session.
Etc, from the excel file, transformed table, "Table_StudentIDListV2" The name FENI appearing twice is wrong, instead i want it to display just a single name FENI with the latest year while maintaining a constant GUID number and not a changing GUID numbers
Thank you
NB: please use the last attachement file:
May 6, 2022
I intend to dynamically fetch Excel tables from a folder in real-time, append them together, and generate a unique identifier. This unique identifier should incorporate the latest class and year/session information while maintaining the same unique GUID for each student. For students in JSS classes (JSS1 to JSS3), the unique ID will have a prefix of '5', while for SS classes (SS1 to SS3), the prefix will be '2'. This ID structure remains consistent regardless of changes in class or year/session.So if a student moves from JSS1 TO JSS2, for instance, what i want is the current session year to display while retaining the UNIQUE ID number, ID, will change , only if he or she crosses to the senior classes.
I have made so many attempts, but all id are recalculating? I need help.
This is the sample zip folder :
This is the final transformation file:
Thank you
1 Guest(s)