Forum

Thank you all,i was able to use Appscript to accomplish this task..

I intend to dynamically fetch Excel tables from a folder in real-time, append them together, and generate a unique identifier. This unique identifier ...

@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,...

Yes,i have tried it,but no solution. I sorted the session in descending order ,with table.buffer and remove duplicates if any in the GUID column,ye...

@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...

Please , who can resolve the above subject matter for me. I have be looking forward from the public with a view to providing a solution to the chal...

Thank you @Catalin, sincerely this works like magic!

Thank you, so there is no way to make it generate just 8 or 10 digit number GUI while still ensuring uniqueness of the number generated? Secon...

This is a follow up, to my previous question "Generate a unique passcode accross records in powerquery@ Please i have added a customIndex column...

HOW PLEASE? this is the challenge i am having, and have uploaded it as an attachement ?

This is the attachments below

Thank you