Data Transformation in Qlik Sense

[sijojoseph22]

Hi All,

We are having data in the below format

Column1	Column2	Resource
Development	Java	A
Development	Java	B
Development	Oracle	C
Development	HTML	D
Development	QS	E
Development	QS	F
Testing	Automated	Z
Testing	Manual	Y
Testing	Both	W
Testing	Both	U

and need to convert into the below format.

Development	Development Resource	Testing	Testing Resource
Java	A	Automated	Z
Java	B	Manual	Y
Oracle	C	Both	W
HTML	D	Both	U
QS	E
QS	F

Please could you advise how to achieve this.

Thanks,

Sijo

[Vegar]

Please explain the logic behind finding which development row that is linked to which test row. 

In other words: why is Java A on the same row as Development Z and why do you have no test on the QS development rows?

[Vegar · Accepted solution]

To just get the list split into four columns do something like this

Load

RowNo()

Column1 as development, 

Column1 as DevResource

From data where Column1 ='Development';

Join

Load

RowNo()

Column1 as Testing, 

Column1 as TestResource

From data where Column1 ='Testing';