asked on
Add number to New Column if the row starts at AAA with 1 in the Same Filename
Hello Experts,
I have SQL table columns:
UniqueID
Filename
DataName
NewColumn
If the Filename starts with AAA in row then 1, if there are more than AAA in rows with the same filename then starts with 1 then 2 then 3 in NewColumn.
Please see attach file.
Thank you for all your help.
Add-number-to-New-Column-if-the-row.xlsx
I have SQL table columns:
UniqueID
Filename
DataName
NewColumn
If the Filename starts with AAA in row then 1, if there are more than AAA in rows with the same filename then starts with 1 then 2 then 3 in NewColumn.
Please see attach file.
Thank you for all your help.
Add-number-to-New-Column-if-the-row.xlsx
Microsoft SQL ServerSQL
Last Comment
Queennie L
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
@RyanChong:
OMG! It is working.
Thank you and Thank you again and again for your help.
I really appreciate it for you intelligence and expertise.
OMG! It is working.
Thank you and Thank you again and again for your help.
I really appreciate it for you intelligence and expertise.
I will test your code. I will let you know.
Thank you again for your help.