Grouping produces error

[Stacker]

I split a column by a space delimiter, after I have unpivoted the index column and try to group
i get the following error:



"DataFormat.Error: We couldn't convert to Number.

Details:

a"

How do i fix this?

 

[JEC]

So somewhere after the split you are trying to convert an “a” to a number, which is not possible

 

[Stacker]

I just removed errors and it worked.