BJ Data Tech Solution

Specialized on Data processing, Data management Implementation plan, Data Collection tools - electronic and paper base, Data cleaning specifications, Data extraction, Data transformation, Data load, Analytical Datasets, and Data analysis. BJ Data Tech Solutions teaches on design and developing Electronic Data Collection Tools using CSPro, and STATA commands for data manipulation. Setting up Data Management systems using modern data technologies such as Relational Databases, C#, PHP and Android.

all possible pairwise combinations for specific companies in a specific year and in a specific country without repitition
all possible pairwise combinations for specific companies in a specific year and in a specific country without repitition

Hello,
I would like to find all possible pairwise combinations for specific companies in a specific year and in a specific country.

YEAR	COUNTRY	AUDIT FIRM	CITY
2012	Belgium	EY	Brussels
2012	Belgium	EY	Antwerp
2012	Belgium	EY	Liege
2013	Belgium	KPMG	Brussels
2013	Belgium	KPMG	Antwerp
2013	Belgium	KPMG	Liege

so that the result is in this format

YEAR	COUNTRY	AUDIT FIRM	CITY	CITY1	CITY2
2012	Belgium	EY	Brussels	Brussels	Antwerp
2012	Belgium	EY	Antwerp	Antwerp	Liege
2012	Belgium	EY	Liege	Liege	Brussels
2013	Belgium	KPMG	Brussels	Brussels	Antwerp
2013	Belgium	KPMG	Antwerp	Antwerp	Liege
2013	Belgium	KPMG	Liege	Liege	Brussels

Appreciate your help

BJ Data Tech Solution

0 Response to all possible pairwise combinations for specific companies in a specific year and in a specific country without repitition

Post a Comment