Dividing my data

[Anonymous]

Hi,

I have a dimension that shows two different values separated by a comma, can I get these two values in to two different columns/dimensions?

I would like to have the numbers (ex. 102 or 105) in one column of the table and the letter combinations in one.

Thank you!

[sunny_talwar]

You can do like this in the script

LOAD Subfield(Totals, ',', 1) as Number,

          SubField(Totals, ',', 2) as Text

FROM ....