I’m trying to collapse a few columns into one column during ingest. Specifically, trying to convert a bunch of bool columns into a single dimension:
case when column1 = true then ‘Value 1’
when column2 = true then ‘Value 2’
else ‘Value 3’
end as newDimColumn
Is there a way to specify this in the batch spec?