Date to Text column

[gheyman]

This is for Excel Power Query: I need to add a new column to a table and I want to populate it using todays date hour and seconds (as text) and concatenate that with the "Index" column. I am trying to create a unique identifier that will never be repeated. I think this would be the best way. Open to other options as well.

Thank you very much for the help - new to power query.

 

[JGordon11]

let
    Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Name", type text}, {"Data", Int64.Type}}),
    #"Added Index" = Table.AddIndexColumn(#"Changed Type", "Index", 1, 1, Int64.Type),
    #"Added Custom" = Table.AddColumn(#"Added Index", "Custom", each DateTime.LocalNow()),
    #"Inserted Merged Column" = Table.AddColumn(#"Added Custom", "ID", each Text.Combine({Text.From([Index], "en-US"), Text.From([Custom], "en-US")}, " - "), type text),
    #"Removed Columns" = Table.RemoveColumns(#"Inserted Merged Column",{"Index", "Custom"})
in
    #"Removed Columns"

Book1
	A	B	C	D	E	F	G
1	Name	Data		Name	Data	ID
2	Adam Ant	12		Adam Ant	12	1 - 9/10/2021 11:37:19 AM
3	Bruce Banner	9		Bruce Banner	9	2 - 9/10/2021 11:37:19 AM
4	Charlie Chaplin	15		Charlie Chaplin	15	3 - 9/10/2021 11:37:19 AM
5	Delta Dawn	4		Delta Dawn	4	4 - 9/10/2021 11:37:19 AM
6	Emilio Estevez	13		Emilio Estevez	13	5 - 9/10/2021 11:37:19 AM
7	Fannie Farmer	14		Fannie Farmer	14	6 - 9/10/2021 11:37:19 AM
8	Galileo Galilei	1		Galileo Galilei	1	7 - 9/10/2021 11:37:19 AM
9	Harry Houdini	7		Harry Houdini	7	8 - 9/10/2021 11:37:19 AM
10	Igor Ivanov	11		Igor Ivanov	11	9 - 9/10/2021 11:37:19 AM
11	Jonah Jameson	5		Jonah Jameson	5	10 - 9/10/2021 11:37:19 AM
12	Kris Kristofferson	10		Kris Kristofferson	10	11 - 9/10/2021 11:37:19 AM
13	Lois Lane	3		Lois Lane	3	12 - 9/10/2021 11:37:19 AM
14	Micky Mantle	16		Micky Mantle	16	13 - 9/10/2021 11:37:19 AM
15	Nick Nolte	8		Nick Nolte	8	14 - 9/10/2021 11:37:19 AM
16	Ozzy Osbourne	6		Ozzy Osbourne	6	15 - 9/10/2021 11:37:19 AM
17	Pol Pot	2		Pol Pot	2	16 - 9/10/2021 11:37:19 AM
18
Sheet13