Is someone can help me to write a code to add "RankID" column in my source file?
Sample Source Data
Source_id,sta_id ,Address1 ,City ,PaymentMethod,Invoice_Detail
21 ,KXV ,Rd , , ,
22 ,KXV ,PO Box234 ,Dallas, ,
31 , , , ,Cash ,;8555-4
42 ,Paid Sat , , , ,
Y ,180217 ,6 ,23550 , ,800-345-969
21 ,CNN ,TV , , ,
22 ,CNN ,PO Box 99 ,Chicag, ,
31 , , , ,Cash ,224;86799
42 ,Paid Sun , , , ,
Y ,180218 ,6 ,3456 , ,888-191-1900
Y ,180226 ,7 ,456 , ,800-900-8999
What I want after add/populate "RankID"
RankID,Source_id,sta_id ,Address1 ,City ,PaymentMethod,Invoice_Detail
1 ,21 ,KXV ,Rd , , ,
1 ,22 ,KXV ,PO Box234 ,Dallas, ,
1 ,31 , , , ,Cash ,;8555-4
1 ,42 ,Paid Sat , , , ,
1 ,Y ,180217 ,6 ,23550 , ,800-345-969
2 ,21 ,CNN ,TV , , ,
2 ,22 ,CNN ,PO Box 99 ,Chicag, ,
2 ,31 , , , ,Cash ,224;86799
2 ,42 ,Paid Sun , , , ,
2 ,Y ,180218 ,6 ,3456 , ,888-191-1900
2 ,Y ,180226 ,7 ,456 , ,800-900-8999
Thanks in advance.