find the two fields

[rajareddyjkl]

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.

[Anil_Babu_Samineni]

May be this

First 10000 Load * From T1;

First 5000 Load * From T2;

[its_anandrjs]

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;

[effinty2112]

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

[Kushal_Chawda]

I did not understand it. Can you please elaborate?

[rajareddyjkl]

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 ?

[rajareddyjkl]

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 ?

[its_anandrjs]

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

[rajareddyjkl]

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 ?

[rajareddyjkl]

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>