I need help with converting a JSON file into a CSV file while avoiding duplicate values in the output. I want to include four columns in my CSV file without repeating any data.
My approach involves storing variables in an array and writing them to a CSV file. However, I'm struggling with preventing duplicates in the 'Name' column. If there is a duplicate entry, I don't want it to be included in the final output.
ForEach ($fileEnvironment in $jsonVariables.ScopeValues.Environments) {
#Create empty array
$dataArray = @()
ForEach ($fileVariable in $jsonVariables.Variables) {
if($fileVariable.Description -eq $null) {
$fileVariable.Description = 'No Description'
}
if (!!$fileVariable.Scope) {
if (!!$fileVariable.Scope.Environment) {
if ($fileEnvironment.Id -eq $fileVariable.Scope.Environment[0]) {
#Add fileVariable to the array
$dataArray += $fileVariable
}
}
}
}
$filename="$($outputPath)\$($projectName)_$($fileEnvironment.Name).csv"
if ($dataArray.Count -ne 0) {
$dataArray | Select-Object -Property
Name,Type,Value,Description | Export-Csv -NoTypeInformation -Path
$fileName
}
In the resulting CSV file, only unique values should be present in the 'Name' column. For example, we currently have 'apiConfig' repeated, but I want to see just one instance of 'apiConfig' in the CSV:
Name Type Value Description
apiConfig String ... No Description
apiconfig String ... No Description