As a text through SQL

[somacdc]

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.

[pasi_lehtinen]

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.

[somacdc]

Oracle database engine

[pasi_lehtinen]

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

[somacdc · Accepted solution]

After using preceding load. issue has been resolved.

Thanks for your kind support.