DM - Multi column all data type load fails with period as driver
We are trying to load multi column file with all data type option with period in column but it fails. If we change it to numeric type it runs succesfully. The only reason we are trying all data type is we need to execute the rule from DM and it runs only when all data type is selected.
below is the error
HspOutlineLoad::dateFormatSpecified is true, SessionHalDateFormat stored on session: M/d/yy, sessionId: 849264432
[Thu Feb 18 09:51:16 UTC 2021]Unable to derive load dimension name from header record for data load (/SDM:<autodetect>), found multiple potential load dimension names: Scenario, Account