Showing results for 
Search instead for 
Did you mean: 

File load with boolean values in sap analytic

0 Kudos

Hi, I'm trying to upload a file which contains measure values as 1 and 0 and system has mapped the field to Boolean data type. In Review import section, it is giving error as "only numeric values allowed" for measure field. Can anyone please help one this.

Accepted Solutions (1)

Accepted Solutions (1)

Active Contributor


You can change the data type of that measure column from Boolean to Integer/other data type in the data wrangling. SAC auto detects data type based on first few thousand records. As your data is mostly 1 and 0, it detects as Boolean.

Hope it helps !!

Please upvote/accept if this helps .


Answers (0)