topic multiple field separators in script in QlikView

multiple field separators in script

Fri, 17 Apr 2009 18:24:03 GMT

I have the following issue:

My input file has two record separators, fields 1 to n are separated by '&', and n to last are separated by tab. Is there an option to easily load the entire table in one load statement?

regards,

Hellmar

multiple field separators in script

hectorgarcia — Fri, 17 Apr 2009 19:48:49 GMT

hellmar can you post an example please about how looks your original data ?

Hector

multiple field separators in script

Fri, 17 Apr 2009 19:54:21 GMT

like this:

(see attachment)

multiple field separators in script

rwunderlich — Sat, 18 Apr 2009 02:26:44 GMT

You could load it using tab as a delim. All the & delimited fields would wind up in the first field. Parse those in a preceeding load using subfield(F1, '&',n).


LOAD
 subfield(F1,1) as netmindsid,
 subfield(F1,2) as ext_ref,
 etc...
;
LOAD
 [netmindsid&ext_ref&aid_seq&atyp_seq&aid1&aid2&aid3&aid4&aid5&atyp1&atyp2&atyp3&atyp4&atyp5&starttime&s_viewtime&s_depth&aid_last&atyp_last] as F1,
 Sessions,
 Clicks,
 StartClicks,
 EndClicks,
 ViewTime,
 AvgViewTimePerClick,
 AvgViewTimePerSession,
 AvgClicksPerSession,
 SessionClicks,
 SessionViewTime,
 SessionAvgViewTimePerClick,
 SessionAvgViewTimePerSession,
 SessionAvgClicksPerSession
FROM sample.txt (ansi, txt, delimiter is '\t', embedded labels, msq);

-Rob