Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
You can do like this in the script
LOAD Subfield(Totals, ',', 1) as Number,
SubField(Totals, ',', 2) as Text
FROM ....