Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
can you alias a field in the mapping load table?
Maybe or maybe not, but I don't see why it would matter. Please explain if you do.
Mapping tables does not care about field names. You don't get auto concatenate due to field naming, concatenation only happens to following unnamed mapping tables or mapping tables with the common title. The field names have no effect as I experience it.
The script below will return two map tables , MAP_KeyA and MAP_KeyB, because there are two name definitions.
alias MyKey as Key; //This row does not have any effect
MAP_KeyA: //Map name is important
MAPPING LOAD * inline [
Key, Value
A, 1
];
MAP_KeyB: //Map name is important
MAPPING LOAD * inline [
MyKey, Value
B, 2
];
The script below will return one mapping table MAP_KeyA due to the map name and autoconcat for the unnamed map. Notice the field names are not the same.
MAP_KeyA:
MAPPING LOAD * inline [
Key, Value
A, 1
];
MAPPING LOAD * inline [
MyKey, MyValue
B, 2
];
MAP_KeyA:
MAPPING LOAD * inline [
YourKey, YourValue
C, 3
];
I agree. Mapping tables do not care about the field names. The first field is the lookup key and the second is the returned value, regardless of names. The mapping table is automatically dropped at the end of the load.