Information on how the AgileData.io product works
Other information on the AgileData.io product
The way we work as a company
Agile Data Literacy
Sometimes you need to wrap the output data ion quotes. For example you have data that is pre-fixed with 0 and when you iport the output into Excel it drops the 0, so you want to wrap that data in ” “.
concat(‘text value’ , field name , ‘text value’)
Puts a ” at the beginning and end of the field value.
Rule Type = Calculated Output Field
Rule Attribute = concat(‘”’, postCode , ‘”’) : PostCode
5035 become “5034”
0340 becomes “0430”
Table Of Contents