Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
My raw excel data format is as per below
Eval No. | Evaluation 1 | Evaluation 2 | Evaluation 3 | Evaluation 4 |
Evaluator Name: | W | X | Y | Z |
Staff Name: | A | B | C | D |
Score | 70 | 80 | 90 | 100 |
What i want is the first column values to become the column headers, and the remaining column data to become the row data
Eval No. | Evaluator Name: | Staff Name: | Score |
Evaluation 1 | W | A | 70 |
Evaluation 2 | X | B | 80 |
Evaluation 3 | Y | C | 90 |
Evaluation 4 | Z | D | 100 |
I would like to know how i can do this without tampering with the raw excel data format. Thank you.
Hi Leow,
You can use Transformation wizard to achieve the above result.
LOAD [Eval No.],
[Evaluator Name:],
[Staff Name:],
Score
FROM
Book11.xlsx
(ooxml, embedded labels, table is Sheet1, filters(
Transpose()
));
Hi Leow,
You can use Transformation wizard to achieve the above result.
LOAD [Eval No.],
[Evaluator Name:],
[Staff Name:],
Score
FROM
Book11.xlsx
(ooxml, embedded labels, table is Sheet1, filters(
Transpose()
));
Hi,
the Import wizard can help you with this kind of transformations.
Just use the transpose option you can find there.
Regards
Marco
while load the data from excel file use transformation step...
You can also try a CrossTable load:
CrossTable(EvaluationNumber, Value)
LOAD * FROM MyExcelFile.xlsx (ooxml, embedded labels, table is Sheet1);