topic Text (expression) in QlikView

Text (expression)

Fri, 13 Jul 2012 00:07:30 GMT

Is there a way to load all the data from a source as text without having to reference each field individually?

If I have a table abc with

Code1

Code2

Description3

All fields can be alpha numberic so if Code1 = 00361 and Code2 = 0032 and Desciption3 = 000000009 the precdiing 0's need to remain.

Since all fields need to be read is as text is there a way to specify that for the entire table?

Thanks for any help.

Fri, 13 Jul 2012 01:54:37 GMT

you can try:

load text(Code1) as Code1,text(Code2) as Code2,text(Description3) as Description3 from abc.txt;

Kiran Rokkam.

Fri, 13 Jul 2012 02:20:58 GMT

Thanks Kiran.

I didn't know if I could ensure they are all text in one statement such as

Load

Text(*)

from abc

so I would not need to code text for all the fields.

Sat, 14 Jul 2012 14:47:41 GMT

I want to load all the fields from table abc.

Instead of coding

Load

Text(field1), as field1,

Text(field2) as field2,

Text(fieldx) as fieldx

from table abc

is there anyway to load in all the fields from the table as text in a single statement without having to reference each field in the load statment?

Thanks.