Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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"
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 ... ;
You can do this
Pick(ColumnName + 1, 'inactive', 'active')
How would I add this? Within the Data load Editor? or After my FROM ---- WHERE? Or would this be within the sheet?
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 ... ;
it worked, thank you so much Sunny_talwar!
Amazing