| Note |
|---|
When importing data with date dimension, BellaDati will always check for valid date format. |
If the date is missing or has wrong format, data will not be imported. You can use transformation script to handle these rows and modify them before being imported into BellaDati. Following code checks if date is missing or is in default 00.00.0000 format. | Code Block |
|---|
if (!value(1) | value(1)=='0.0.0000'){
return '01.01.1900 00:00:00'
}
else {
return value(1)
}
|
Transformation script returns either dummy date or original value, depending on result of IF condition. | Note |
|---|
After this transformation, all data will be imported. It is up to you how to report and analyze rows with dummy date. |
Transformation scripting |