Regarding variable type mismatch
I was loading data in SAP PA 2.2 automated mode, and for some reason when I click the analysis button in Data description screen the tool can't recognise the date fields as date, it will take the date column as number. And If I manually edit the type to date and run the algorithm, the tool throws error. And sometimes it does recognise the date fields. I am taking data from flat excel files.
Want to understand is there any specific format of date for which the tool recognise it correctly?
Armelle ANDRE replied
If the date variable is not recognized when clicking "Analyze", forcing it is not helpful. It means that Automated Analytics couldn't interpret the information correctly.
To change that, you need to go 1 step back (to the data source selection panel) and click on the Advanced Settings button :
Then, click on File Settings and check the box in front of Specify Date Format. Specify from the list in which order Day, Month and Year are specified in your dataset and then enter the separator that is used as seen below.
Note that if your date variable is a string in a database and contains months names (e.g. "Jan" or "January"), it won't be possible to proceed this way. You'll need a real date variable and have to convert the string to a date or datetime.
In Excel, months may appear with their name but it's just a display option you can change so that numbers are displayed for months.
Hope this helps,