Link to home
Start Free TrialLog in
Avatar of SURESH0518
SURESH0518

asked on

How to get unique count on first column in a csv file using powershell script

I have a csv file with  two columns orderid,price
order_id,price
10000,90.00
10000,91.00
10001,100.00

I need unique count of order_id using powershell script.
my output should be 2 since unique orders 10000,10001
SOLUTION
Avatar of footech
footech
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of SURESH0518
SURESH0518

ASKER

I have csv file is 25 MB and when I apply it takes sometime and can I make it faster
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial