topic Re: Area:Dual in Qlik Learning Discussions

Area:Dual

Tue, 20 Jan 2015 06:56:11 GMT

Hi all, can any 1 suggest a way 2 my problem:

****SCRIPT is

example:

LOAD dual(text,no) as [dual-example] from

[..\sample-data-for-dual.txt]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

****data in text file

text,no

high,1

medium,2

low,1

Requirement:

high,medium,low have 2 b displayed in qlik view. how to do?

problem:

Re: Area:Dual

hic — Tue, 20 Jan 2015 07:04:21 GMT

You cannot assign two different texts to the same number. In your text file, both high and low have the value 1. If you instead use

text,no

high,3

medium,2

low,1

it will work.

HIC

Re: Area:Dual

Tue, 20 Jan 2015 07:10:07 GMT

s henric i knew tat tell me a way of displaying all data by any way like concatenating with any new numbering like tat....as it is client requirement

Re: Area:Dual

hic — Tue, 20 Jan 2015 09:11:23 GMT

Dual in combination with that requirement doesn't make sense. So, maybe you should discuss this with your client. Or you shouldn't use dual.

I see the following possibilities:

no & '. ' & text as Field,

Dual(no & '. ' & text, RecNo()) as Field,

HIC

Re: Area:Dual

Tue, 20 Jan 2015 12:14:39 GMT

i got when i scripted as:

example:

LOAD dual(text,no) as [dual-example] from

[..\sample-data-for-dual.txt]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

load Dual(text &'.' & no,RecNo()) as Fieldnew from

[..\sample-data-for-dual.txt]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

but not when i scripted as:

example:

LOAD dual(text,no) as [dual-example] from

[..\sample-data-for-dual.txt]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

load Dual(text &'.' & no,RecNo()) as Fieldnew resident example;

wat might b the reason henric?

Re: Area:Dual

hic — Tue, 20 Jan 2015 14:39:24 GMT

If you make one single load (no load resident) like the following:

Load

dual(text,no) as [dual-example1],

Dual(text &'.' & no,RecNo()) as [dual-example2]

From [..\sample-data-for-dual.txt] (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

What do you get then?

Further - Why do you want to use Dual()? What is the goal?

HIC

Re: Area:Dual

Wed, 21 Jan 2015 06:36:39 GMT

Hi henric,

resident load is used 2 load recently loaded tables right? Then y it throws error when i done as-

example:

LOAD dual(text,no) as [dual-example] from

[..\sample-data-for-dual.txt]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

load Dual(text &'.' & no,RecNo()) as Fieldnew resident example;

Re: Area:Dual

hic — Wed, 21 Jan 2015 06:55:22 GMT

In your script, the table "example" does not contain any field called "text" or "no". With these fields lacking, the resident load will of course fail.

HIC

Re: Area:Dual

Fri, 23 Jan 2015 06:11:26 GMT

example:

LOAD dual(text,no) as [dual-example] from......

text,no will b stored as fields right n tat will b overridden by "dual-example"