How to change 1 or 0 to the words "Active" or "Inactive" within a table on a column sheet

[kfloresc]

I have data loaded and made a table within a sheet. For this specific column in that table the values are either 1 or 0. I want to change those output to be seen as "active" or "inactive"

[sunny_talwar]

You can do this

Pick(ColumnName + 1, 'inactive', 'active')

[kfloresc]

How would I add this? Within the Data load Editor? or After my FROM ---- WHERE? Or would this be within the sheet?

[sunny_talwar · Accepted solution]

If you are doing this in the script, you can add it to your load statement

LOAD ColumnName,
Pick(ColumnName + 1, 'inactive', 'active') as NewColumnName,
....
FROM/Resident ... ;

[kfloresc]

it worked, thank you so much Sunny_talwar!

[sunny_talwar]

Amazing