0

I have below PowerShell logic to copy the data. Now we are moving this logic to the Angular application.

So, I want to save this data in the database table. Could you please advise how can I store them?

In the application, if the user selects the country value, then it should automatically populate the State, Outlook, and Teams Column

if (country -eq "US") {
    $State = "Yes"
    $outlook = "Office 365"
    $Teams = "Office 365"
}
elseif (Country -eq "UK") {
    $state = "NO"
    $outlook = "Exchange"
    $team = Skype
}
marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
POSH Guy
  • 1,798
  • 2
  • 11
  • 15
  • Uhm, lookup means reading data but you're talking about saving stuff. Take a look at [Connect to SQL Server Database from PowerShell](https://stackoverflow.com/questions/25682703) to get an idea. To provide an actual answer we should get more information. – DerSchnitz Dec 05 '20 at 20:41
  • "In the application, if the user selects the country value, then it should automatically populate the State, Outlook, and Teams Column" Have you worked out how you implement this in Angular? Angular is worlds apart from Powershell. Also there is a whole world of data modelling questions here. Do you have a lot of different "Outlook" and "team" settings? – Nick.Mc Dec 06 '20 at 02:19
  • Yes. We have many data which we pull from CSV file. Can I create the same structure in DB – POSH Guy Dec 07 '20 at 06:31

0 Answers0