Grouping objects on the property in PowerShell
I would like the Application and ShortcutName columns to be grouped into one column, while keeping the Version and Architecture columns as they are :
$object | Select-Object -Property Application, Version, Architecture, ShortcutName |
Sort-Object -Property @{expression="Architecture";Descending=$true},Application |
Out-GridView
How can I do that ?
powershell calculated-columns
edited Nov 25 '18 at 15:08
mklement0
135k21252289
asked Nov 25 '18 at 10:04
A. JosonA. Joson
324
add a comment |
I would like the Application and ShortcutName columns to be grouped into one column, while keeping the Version and Architecture columns as they are :
$object | Select-Object -Property Application, Version, Architecture, ShortcutName |
Sort-Object -Property @{expression="Architecture";Descending=$true},Application |
Out-GridView
How can I do that ?
powershell calculated-columns
edited Nov 25 '18 at 15:08
mklement0
135k21252289
asked Nov 25 '18 at 10:04
A. JosonA. Joson
324
add a comment |
I would like the Application and ShortcutName columns to be grouped into one column, while keeping the Version and Architecture columns as they are :
$object | Select-Object -Property Application, Version, Architecture, ShortcutName |
Sort-Object -Property @{expression="Architecture";Descending=$true},Application |
Out-GridView
How can I do that ?
powershell calculated-columns
edited Nov 25 '18 at 15:08
mklement0
135k21252289
asked Nov 25 '18 at 10:04
A. JosonA. Joson
324
I would like the Application and ShortcutName columns to be grouped into one column, while keeping the Version and Architecture columns as they are :
$object | Select-Object -Property Application, Version, Architecture, ShortcutName |
Sort-Object -Property @{expression="Architecture";Descending=$true},Application |
Out-GridView
How can I do that ?
powershell calculated-columns
powershell calculated-columns
edited Nov 25 '18 at 15:08
mklement0
135k21252289
asked Nov 25 '18 at 10:04
A. JosonA. Joson
324
edited Nov 25 '18 at 15:08
mklement0
135k21252289
asked Nov 25 '18 at 10:04
A. JosonA. Joson
324
edited Nov 25 '18 at 15:08
mklement0
135k21252289
edited Nov 25 '18 at 15:08
mklement0
135k21252289
edited Nov 25 '18 at 15:08
mklement0
135k21252289
135k21252289
asked Nov 25 '18 at 10:04
A. JosonA. Joson
324
asked Nov 25 '18 at 10:04
A. JosonA. Joson
324
asked Nov 25 '18 at 10:04
A. JosonA. Joson
324
324
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
In PowerShell you group objects by properties with Group-Object. What you want is not grouping in that sense, but defining a new custom property.
You create custom properties a hashtable with the Name and Expression keys.
Something like this will probably do the trick.
$Expression = {
if ($_.Application) {
$_.Application
}
else {
$_.Shortcut
}
}
$object |
Select-Object -Property @{ Name = 'Application'; Expression = $Expression }, Version, Architecture |
Sort-Object -Property @{expression="Architecture";Descending=$true},Application |
Out-GridView
The expression checks whether the Application property is filled. If so, it will use the existing application name, otherwise it will take the Shortcut property as application name.
answered Nov 25 '18 at 12:18
vrdsevrdse
1,749214
The Application property is always filled. I don't want substitute the Application property with the Shortcut property but have one column with the content of this 2 properties.
– A. Joson
Nov 25 '18 at 12:50
Edit : That works. Thank you !
– A. Joson
Nov 25 '18 at 12:59
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53466437%2fgrouping-objects-on-the-property-in-powershell%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
In PowerShell you group objects by properties with Group-Object. What you want is not grouping in that sense, but defining a new custom property.
You create custom properties a hashtable with the Name and Expression keys.
Something like this will probably do the trick.
$Expression = {
if ($_.Application) {
$_.Application
}
else {
$_.Shortcut
}
}
$object |
Select-Object -Property @{ Name = 'Application'; Expression = $Expression }, Version, Architecture |
Sort-Object -Property @{expression="Architecture";Descending=$true},Application |
Out-GridView
The expression checks whether the Application property is filled. If so, it will use the existing application name, otherwise it will take the Shortcut property as application name.
answered Nov 25 '18 at 12:18
vrdsevrdse
1,749214
The Application property is always filled. I don't want substitute the Application property with the Shortcut property but have one column with the content of this 2 properties.
– A. Joson
Nov 25 '18 at 12:50
Edit : That works. Thank you !
– A. Joson
Nov 25 '18 at 12:59
add a comment |
In PowerShell you group objects by properties with Group-Object. What you want is not grouping in that sense, but defining a new custom property.
You create custom properties a hashtable with the Name and Expression keys.
Something like this will probably do the trick.
$Expression = {
if ($_.Application) {
$_.Application
}
else {
$_.Shortcut
}
}
$object |
Select-Object -Property @{ Name = 'Application'; Expression = $Expression }, Version, Architecture |
Sort-Object -Property @{expression="Architecture";Descending=$true},Application |
Out-GridView
The expression checks whether the Application property is filled. If so, it will use the existing application name, otherwise it will take the Shortcut property as application name.
answered Nov 25 '18 at 12:18
vrdsevrdse
1,749214
The Application property is always filled. I don't want substitute the Application property with the Shortcut property but have one column with the content of this 2 properties.
– A. Joson
Nov 25 '18 at 12:50
Edit : That works. Thank you !
– A. Joson
Nov 25 '18 at 12:59
add a comment |
In PowerShell you group objects by properties with Group-Object. What you want is not grouping in that sense, but defining a new custom property.
You create custom properties a hashtable with the Name and Expression keys.
Something like this will probably do the trick.
$Expression = {
if ($_.Application) {
$_.Application
}
else {
$_.Shortcut
}
}
$object |
Select-Object -Property @{ Name = 'Application'; Expression = $Expression }, Version, Architecture |
Sort-Object -Property @{expression="Architecture";Descending=$true},Application |
Out-GridView
The expression checks whether the Application property is filled. If so, it will use the existing application name, otherwise it will take the Shortcut property as application name.
answered Nov 25 '18 at 12:18
vrdsevrdse
1,749214
In PowerShell you group objects by properties with Group-Object. What you want is not grouping in that sense, but defining a new custom property.
You create custom properties a hashtable with the Name and Expression keys.
Something like this will probably do the trick.
$Expression = {
if ($_.Application) {
$_.Application
}
else {
$_.Shortcut
}
}
$object |
Select-Object -Property @{ Name = 'Application'; Expression = $Expression }, Version, Architecture |
Sort-Object -Property @{expression="Architecture";Descending=$true},Application |
Out-GridView
The expression checks whether the Application property is filled. If so, it will use the existing application name, otherwise it will take the Shortcut property as application name.
answered Nov 25 '18 at 12:18
vrdsevrdse
1,749214
answered Nov 25 '18 at 12:18
vrdsevrdse
1,749214
answered Nov 25 '18 at 12:18
vrdsevrdse
1,749214
answered Nov 25 '18 at 12:18
vrdsevrdse
1,749214
1,749214
The Application property is always filled. I don't want substitute the Application property with the Shortcut property but have one column with the content of this 2 properties.
– A. Joson
Nov 25 '18 at 12:50
Edit : That works. Thank you !
– A. Joson
Nov 25 '18 at 12:59
add a comment |
The Application property is always filled. I don't want substitute the Application property with the Shortcut property but have one column with the content of this 2 properties.
– A. Joson
Nov 25 '18 at 12:50
Edit : That works. Thank you !
– A. Joson
Nov 25 '18 at 12:59
The Application property is always filled. I don't want substitute the Application property with the Shortcut property but have one column with the content of this 2 properties.
– A. Joson
Nov 25 '18 at 12:50
The Application property is always filled. I don't want substitute the Application property with the Shortcut property but have one column with the content of this 2 properties.
– A. Joson
Nov 25 '18 at 12:50
Edit : That works. Thank you !
– A. Joson
Nov 25 '18 at 12:59
Edit : That works. Thank you !
– A. Joson
Nov 25 '18 at 12:59
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53466437%2fgrouping-objects-on-the-property-in-powershell%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
