Hi, everyone!
I'm trying to import data from Ecxel file in Datafeed, but I ran into difficulties with dates. There is a column with dates (format cells=Date, for example 14.3.2010) and the next date is created by formula by adding 1.
When I import the file in Aris MashZone, the dates is imported as Text field ( look 1.jpeg). Then I used operator 'Replase Text' and replase 'T00:00:00' with nothing (look 2.jpeg). As results I have date in text format. Then I use operator 'Change data type' (look 3.jpeg).
I don't want to change the excel file, so please told me how to solve my problem.
Thanks in advance!
Mariya Chapkanova
Markus von den Driesch on
Please check the date pattern, which is used in the 'Change data type' operator. You can specify a parse pattern when clicking on the icon on the left-hand side of the data type selector buttons.
Try the pattern: yyyy-MM-dd