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
B, Bonnie, etc.
My initial attempt (without the MAPPING LOAD) was something like this:
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.
I recommend to separate these steps:
1 - crossatable load into a table.
2 - create map:
MAPPING LOAD DISTINCT
Edit: missed MAPPING 😞
Try using the Transpose transformation instead:
mapping LOAD @1 as xColumn,
@3 as xValue
[Main.xlsx](ooxml, no labels, table is Sheet1, filters(
I don't see an option to upload -- but here's a masked version of the file. It's pretty straightforward. I need a mapping of:
Do I not have enough merit points yet to upload files?
It's not about the merit points... Click "use advanced editor", it is on the top right of the reply window. After this, you can see "attach" on the bottom right.