06-03-2016 06:41 AM
I Have parsed the field "Street" and as a result I got threea additional fields: "Street Name, House Number, Extension".
However, I already had the fields "Street_NAME" and "HOUSE_NUM".
What I would like to do is to make a third column which will be populated in in a way that first the values from the "Street_NAME" column are taken, and if that value does not exist, the value from the parsed columnd "treet Name" is taken. Same principle should be applied to House Number as well.
How, and with which nodes can I make this?
06-03-2016 07:44 AM
you could try using the coalecsec function.
new1=coalescec(Street_NAME, Street Name);
new2=coalescec(HOUSE_NUM, House Number);