...
Code Block |
---|
out = MAP({
expressions = [
['bid','renamed_bid'] /// Renaming of attribute
/// Remark: The output only contains attributes/expressions that are given here, so removing an attribute is the by not using it here
]}
,nexmark:person)
/// Simple split name in forename and lastname by looking for the first blanc
out2 = MAP({
expressions = [
['Substring(name,0,indexOf(name," "))','forename'],
['Substring(name,indexOf(name," ")+1)','lastname'],
]
},nexmark:person
)
/// Splitting of attribute into list
/// Split string into substrings by " "
presplitted = MAP({
expressions = [
['split(name," ")','splittedName']
]
},nexmark:person
)
/// access first and last element of list
out3 = MAP({
EXPRESSIONS = [
['splittedName[0]','forename'],
['elementAt(splittedName,size(splittedName)-1)','lastname']
]
}, presplitted
)
/// access first and last element of list with special function
out4 = MAP({
EXPRESSIONS = [
['first(splittedName)','forename'],
['last(splittedName)','lastname']
]
}, presplitted
)
/// List functions
out5 = MAP({
EXPRESSIONS = [
['sublist(splittedName,0,1)','nameAsList'],
['sublist(splittedName,1)','nameAsList2'],
['rest(splittedName)','allLastElements']
]
}, presplitted
) |
Transforming attributes
Tranformation can also be done with the Map operator.
...