Skip to content

Discern merged properties for multiple joins #16

@iRon7

Description

@iRon7

In case multiple joins are chained, I would like to be able to separate/discern/rename the merged properties in once in the last cmdlet in the chain.

Example:

$AAA = ConvertFrom-Csv @'
Number,Name,Domain
Z001,ABC,Domain1
Z002,DEF,Domain2
Z003,GHI,Domain3
'@

$BBB = ConvertFrom-Csv @'
Number,Name,Domain
Z001,ABC,Domain1
Z002,JKL,Domain2
Z004,MNO,Domain4
'@

$CCC = ConvertFrom-Csv @'
Number,Name,Domain
Z005,PQR,Domain2
Z001,ABC,Domain1
Z001,STU,Domain2
'@

$DDD = ConvertFrom-Csv @'
Number,Name,Domain
Z005,VWX,Domain4
Z006,XYZ,Domain1
Z001,ABC,Domain3
'@

$AAA |FullJoin $BBB -On Number |FullJoin $CCC -On Number |FullJoin $DDD -On Number -Discern *1,*2,*3,*4 | ft

Number Name1 Name2 Name3 Name4 Domain1 Domain2 Domain3 Domain4
------ ----- ----- ----- ----- ------- ------- ------- -------
Z001   ABC   ABC   ABC   ABC   Domain1 Domain1 Domain1 Domain3
Z001   ABC   ABC   STU   ABC   Domain1 Domain1 Domain2 Domain3
Z002   DEF   JKL               Domain2 Domain2
Z003   GHI                     Domain3
Z004         MNO                       Domain4
Z005               PQR   VWX                   Domain2 Domain4
Z006                     XYZ                           Domain1

Metadata

Metadata

Assignees

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions