Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm loading data into the Qlik Sense app from BigQuery using the following script:
[tests]:
SELECT ID, passed
FROM `db.table`;
In the original data, passed can be either True or False. After being loaded into the application, it shows up as 1 or 0. How do I change it back to True or False?
Hello,
Try this following script:
[tests]:
LOAD
ID,
IF(passed=1,'True','False') AS passed;
SELECT
ID,
passed
FROM `db.table`;
Cordialy.