Advertisement
Guest User

Untitled

a guest
Feb 21st, 2019
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. $objs =@();
  2. $output = Import-csv -Path C:UsersDanDesktopExternal_ID_Test.csv | ForEach {
  3. $Object = New-Object PSObject -Property @{
  4. Employee_ID = $_.Employye_ID
  5. Base_Cost_Center = $_.Base_Cost_Center
  6. Entity = $_.Entity
  7. ExternalID = [String]::Concat($_.Entity,$_.Base_Cost_Center)
  8. }
  9. $objs += $Object;
  10. }
  11. $objs
  12. $objs | Export-CSv C:UsersDanDesktopExport_External_ID_Test.csv -NoTypeInformation
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement