...
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 = [ ['substring()','firstname'], ['substring('splittedName[0]','forename'], ['elementAt(splittedName,size(splittedName)-1)','lastname'] ] }, presplitted ) /// access first and last element of list with special function out4 = MAP({ EXPRESSIONS = [ ['splittedName[0]','forename'], ['last(splittedName)','lastname'], |
...
]
}, presplitted
) |
Transforming attributes
Tranformation can also be done with the Map operator.
...