Downloading the transformed values from a perspective table

If I have a dataset with integers that get transformed into their text equivalent using an embedded view in a perspective table, can I download the transformed values from a property or do I need to handle the transformation by myself again while doing the download to csv?

Data in Table

Data on Display

Data when downloaded (back to integers)



The data is never not integers. I’m assuming you’re passing an integer into a view, using the parameter and displaying the text equivalent. If you use the dataset viewer, you’ll see the data never changes to your text equivalents. If you don’t mind the actual underlying data changing, you could update the appropriate cells with whatever text is in your embedded view. I wouldn’t recommend this and as soon as you refresh the binding, it’ll just retrieve integers from the DB again (I’m assuming that’s the setup).

Would you could do instead (what I would do) is to retrieve the laneDetail as text from the DB (if that’s where it’s coming from) using a CASE statement:

    CASE laneDetail 
        WHEN 1 THEN 'Lane Full'
        WHEN 0 THEN 'Lane Empty'
    END laneDetailText

Why we don’t transform it at the time of query is because the data is then bigger across all transit (string vs. integer)


A script transform would be more efficient (DB → GW) than embedded views, and fix the download problem.

1 Like

Thanks for the input gents. I ended up making a function that converts the target columns post query but before assigning the data to the perspective table.