topic Re: how to separate field in QlikView

how to separate field

rohit214 — Wed, 09 Nov 2011 06:45:48 GMT

hi all

i have data in notepad shown below

Sample1:

eid|name|salary

123|ravi|100

234|arun|200

345|rathish|300

456|rohit|400

sample2:

barcode|value

000001|10000

0 1012|20000

00 111|30000

002222|30000

000088|40000

now what i want ...table should seen like this

	eid
123
234
345
456

same for others....plz help me

thanks rohit

how to separate field

SunilChauhan — Wed, 09 Nov 2011 07:41:46 GMT

while loading you can write

load

subfield(fieldname,'|',1) as EID,

subfield(fieldname,'|',2) as Name,

subfield(fieldname,'|',3) as salary

from abc.text

how to separate field

rohit214 — Wed, 09 Nov 2011 08:47:16 GMT

hi sunil

its give only the EID

remaining shows no values

thanks

rohit

how to separate field

perumal_41 — Wed, 09 Nov 2011 08:52:09 GMT

Hi,

Please upload ur application

Re: how to separate field

Wed, 09 Nov 2011 09:23:44 GMT

Hi,

In your script select the data file using the 'Table Files' option. Set File Type=Delimited, Delimiter = Custom = '|'. And follow further steps and load data.

Hope this helps.

Thanks.

how to separate field

SunilChauhan — Wed, 09 Nov 2011 09:30:52 GMT

edit script-> Table Files-> select the text file-> delimeter-.Custom-> then seach for '|' and select '|'

-> next-> next -...finish

reload the application

now you have 3 fields

Eid, Name and salary

hope this heelps

Re: how to separate field

Fri, 15 Mar 2013 13:37:58 GMT

Hear '123455' this is string formate time .hear how to use delimete ,i.e.time is 12-34-55 whate is function used for written delimeter replay fast friends

Re: how to separate field

SunilChauhan — Sat, 16 Mar 2013 14:48:18 GMT

Try below

Left('123455',2)&'-'&mid('123455',3,2)&'-'&right('123455',2) as time