Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello. I'm trying to set up a mapping load using CROSSTAB. My source is an Excel file. What I need is to pull labels from the second line of the file and have those paired with the letter associated with the column. So my Excel file might look like this:
-: A | B | C | D | E...
1: [extraneous data]
2: Apple | Bonnie | Cherry | Danielle | Endive |
3: [extraneous data]
4: [extraneous data]
I need a mapping table of
A, Apple
B, Bonnie, etc.
My initial attempt (without the MAPPING LOAD) was something like this:
CrossTable(xColumn, xValue)
FIRST 63 LOAD * from [Main.xlsx](ooxml, explicit labels, table is Sheet1);
63 is the number of columns. This works but gives me a third column (in first position) which I don't need and prohibits it from becoming a MAPPING LOAD.
Can someone see a better way? Thanks.
No, just click on the Use advanced editor link (top right of the Reply box).
I see your problem. The column letters from excel can't be used after transposing. You'll have to do as Michael said above. First use Crosstable then do a resident load from the new table.
Thank you all for your time. I'll start looking at Michael's approach.
(I found the Attach option, by the way. I was looking in the menu bar.)