topic Re: As a text through SQL in QlikView

As a text through SQL

somacdc — Tue, 05 Nov 2019 07:57:57 GMT

here is the desire data.

ID	FOLIOS
1686	02
1686	1
1686	105
1686	2
1686	3
1686	4

Load result is as follows after the following query:

HOLDERS:
SQL SELECT
"FOLIOS",
"ID"
FROM "POST"."HOLDERS";

ID	FOLIOS
1686	1
1686	105
1686	2
1686	3
1686	4

Please note that text(FOLIOS) is also used.

Re: As a text through SQL

pasi_lehtinen — Tue, 05 Nov 2019 08:02:51 GMT

Try to convert the field to text already in the SQL query part. The correct syntax depends on your database engine but with MS SQL Server you can either use cast or convert database functions.

Re: As a text through SQL

somacdc — Tue, 05 Nov 2019 09:45:21 GMT

Oracle database engine

Re: As a text through SQL

pasi_lehtinen — Tue, 05 Nov 2019 09:47:03 GMT

Then you should use TO_CHAR() -function I guess.

Re: As a text through SQL

somacdc — Tue, 05 Nov 2019 10:04:11 GMT

After using preceding load. issue has been resolved.

Thanks for your kind support.