topic Re: find the two fields in QlikView

find the two fields

rajareddyjkl — Sat, 09 Sep 2017 18:07:06 GMT

let us assume that I have a two tables in that two tables each have 2 million fields and i want know first table 10,000 field and second table 5000 field and how get the two field names ???

Note: there is no common fields in two tables.

Re: find the two fields

Anil_Babu_Samineni — Mon, 11 Sep 2017 08:52:02 GMT

May be this

First 10000 Load * From T1;

First 5000 Load * From T2;

Re: find the two fields

its_anandrjs — Mon, 11 Sep 2017 11:51:40 GMT

Load your table with Rowno() with limited number of the rows this loads your first 10000 from first table and from second 5000.

Table1:

LOAD * From Source Where RowNo() < 10000;

Table2:

LOAD * From Source Where RowNo() < 5000;

Re: find the two fields

effinty2112 — Mon, 11 Sep 2017 13:36:40 GMT

Hi Raja,

Don't you mean the tables have millions of records rather than fields?

Anyway In your load script add these statements after the fields have loaded:

Let v10000Field1 = Peek('Field1',9999, 'Table1'); //index starts at zero

Let v5000Field2 = Peek('Field2',4999, 'Table2');

If a field is composed of unique values then in script or front end

v10000Field1 = FieldValue('Field1',10000)

Cheers

Andrew

Re: find the two fields

Kushal_Chawda — Mon, 11 Sep 2017 13:55:06 GMT

I did not understand it. Can you please elaborate?

Re: find the two fields

rajareddyjkl — Mon, 11 Sep 2017 17:11:01 GMT

load

Fieldname(10,000,'abc') as Third

Resident abc;

load

Fieldname(5000,'xyz') as onetwo

Resident xyz;

i have done like this . let me know right or wrong ?

Re: find the two fields

rajareddyjkl — Mon, 11 Sep 2017 17:11:33 GMT

load

Fieldname(10,000,'abc') as Third

Resident abc;

load

Fieldname(5000,'xyz') as onetwo

Resident xyz;

i have done like this . let me know right or wrong ?

Re: find the two fields

its_anandrjs — Mon, 11 Sep 2017 17:15:07 GMT

This is wrong way can explain with an example what you want to achieve this is not understandable.

Re: find the two fields

rajareddyjkl — Mon, 11 Sep 2017 17:15:52 GMT

load

Fieldname(10,000,'abc') as Third

Resident abc;

load

Fieldname(5000,'xyz') as onetwo

Resident xyz;

i have done like this . let me know right or wrong ?

Re: find the two fields

rajareddyjkl — Mon, 11 Sep 2017 17:29:14 GMT

i have done like this

abc:

LOAD gglhg,

jjkjkl,

hjhkj,

jghgh,

hbkg,

bhkgh,

jbhjg,

hjhh,

kjklh,

jhb,

hjh,

jmh,

mhjh,

nbjh,

hjhjh

FROM

(ooxml, embedded labels, table is Sheet1);

xyz:

LOAD abc,

cfd,

asd,

ahhh,

lhh,

jkhh,

hjkjkl,

jhjlh,

nmjk,

klgbmn,

mbnnn,

kcg,

abcq,

jhgj,

hghb

FROM

(ooxml, embedded labels, table is Sheet1);

load

Fieldname(5,'abc') as Third

Resident abc;

load

Fieldname(1,'xyz') as onetwo

Resident xyz;

On Mon, Sep 11, 2017 at 10:45 PM, Anand Chouhan <qcwebmaster@qlikview.com>

Re: find the two fields

MarcoWedel — Mon, 11 Sep 2017 22:31:13 GMT

maybe helpful:

Qlik Community Tip: Posting Successful Discussion Threads

How to get answers to your post?

Its not about the answer, rather it’s about the question…

regards

Marco