Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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';
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?
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';