Downloading the transformed values from a perspective table

Ignition
1

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

image
image1621×740 108 KB

Data on Display
image

image
image3276×874 311 KB

Data when downloaded (back to integers)

image
image1457×342 24.1 KB

Thanks,

Nick

2

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:

SELECT
    timestamp, 
    sorter,
    ...
    CASE laneDetail 
        WHEN 1 THEN 'Lane Full'
        WHEN 0 THEN 'Lane Empty'
    END laneDetailText
FROM
    <your_table>
3

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

Nick

4

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

1 Like
5

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.

Cheers,

Nick