Hi All,
I am using read excel function to read the excel file and mapping these values to CDT.
I am giving timestamp field in excel and trying to map with CDT having data type 'Date and Time', and in postgres Db it has timestamp field, but it is not getting mapped to CDT.
NOTE: If I enter only Date then it is getting mapped to CDT and updating the DB, but If I am trying with timestamp field the CDT values are null.
Thanks,
Kiran
Discussion posts and replies are publicly visible
Hi Kiran,
Can you also attach a screenshot of the mapping rule/code you are using to task this dict to CDT? To me, it looks like you might need to change the format of the date, or maybe the datatype of the field in CDT is misconfigured.
Hi Harshit,
Format of the date is fine, whenever I add (8/17/2022 10:10:00) then the file is read by rule but the mapping is not happening for any values to CDT
I need to see how you have configured the casting expression rule. Please attach the code or screenshot of it.
Attaching sample code
Attaching the snap of my rule