Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have an exel file like this:
A | B | C | D | E | F | G | H | I | J | K | L |
---|---|---|---|---|---|---|---|---|---|---|---|
48 | 843 | 3156 | 15 | 481 | 548 | 484 | 218 | 15 | 128 | 412 | 451 |
and I want this:
Type | Value |
---|---|
A | 48 |
B | 843 |
C | 3156 |
D | 15 |
E | 481 |
F | 548 |
G | 484 |
H | 218 |
I | 15 |
J | 128 |
K | 412 |
L | 451 |
So I'm using Crosstable to do this:
Crosstable (Type,Value, 0)
Load A,
B,
C,
D,
E,
F,
G,
H,
I,
J,
K,
L
From ...
but it doens't work, and the result is a table equal to the source.
I don't understand why.
Hi,
yesterday I was stuck on doing a Crosstable without a qualifier column (like what you have here).
try to take your file and insert another column before the column A, insert any value on it.
when doing the crosstable on the Wizard, choose the new column as the qualifier column.
at the end of the script, you can drop this field.
drop field field_name from table_name;
Hi,
yesterday I was stuck on doing a Crosstable without a qualifier column (like what you have here).
try to take your file and insert another column before the column A, insert any value on it.
when doing the crosstable on the Wizard, choose the new column as the qualifier column.
at the end of the script, you can drop this field.
drop field field_name from table_name;
Ok, this solution works, thanks
You're welcome !
Good luck