Palo Community Forum

Hello Palo community,

After serveral attempts mapping single sentence in Palo, I meet always the problem: numeric values, which I don't want to aggregate like informations as percentages or prices. If I define them as measures Palo strikes, because other measures become aggregate. If I attempt to load them as attribute I get other problems, which I declare as following and start with the question:

Isn't it possible to import numeric values as an attribute?

My first attempt doesn't work with ETL, because there was a structure with aggregation. My second attempt: I have elimated the structure, so that I have only single elements in my dimension. But now the ETL prozess for creating the dimension failed with the message:

:com.tensegrity.palojava.PaloException: (1007) error converting a string to a number, string is empty.

I don't import a string field, but a numeric field. What is my mistake?

Thanks for answer!

Hi all,

during the time I found the solution:

the numeric values as attribute must imported as a string value. It is not neccessary to define the source numeric value as a string, but pretend the numeric value would be a string (settings ETL: Transforms, TreeFH, Attribute, here define the numeric value as string)

Thanks!