topic Re: How do we load data in the text format in QlikView

How do we load data in the text format

Tue, 23 Jun 2015 08:52:33 GMT

Hi I am getting some data in flat file in the given format and i want to load these data in a tabular format with two columns Say used % and Description

if the usage % is 100 then there will not be any other line but if its lesser then it will show the components which are not being used .

so i want to capture the usage % in used % colum and component in description

Re: How do we load data in the text format

fvelascog72 — Tue, 23 Jun 2015 09:01:27 GMT

Hi,

Try this:

DATA:

LOAD

Usage%,

If(Usage%=100,null(),Description) as "Description"

Inline [

Usage%, Description

100, XXX

98, YYY

];

Re: How do we load data in the text format

Tue, 23 Jun 2015 09:07:44 GMT

hi The file may not be static and values may change but data will be same format ...i need to load dyanically using transformation

Re: How do we load data in the text format

jagan — Tue, 23 Jun 2015 09:13:05 GMT

Hi,

Try this script

Data:

LOAD DISTINCT *;

LOAD

If(WildMatch(@1, 'Usage*'), Trim(SubField(@1, '=', 2))) AS Usage,

FileName() AS FileName

FROM

[SAMPLE*.txt]

(txt, codepage is 1252, no labels, delimiter is '\t', msq)

WHERE WildMatch(@1, 'Usage*');

LEFT JOIN(Data)

LOAD

If(NOT WildMatch(@1, 'Usage*', 'The following components*'), @1) AS Component,

FileName() AS FileName

FROM

[SAMPLE*.txt]

(txt, codepage is 1252, no labels, delimiter is '\t', msq)

WHERE NOT WildMatch(@1, 'Usage*', 'The following components*');

DROP FIELD FileName;