Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be this
First 10000 Load * From T1;
First 5000 Load * From T2;
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;
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
I did not understand it. Can you please elaborate?
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 ?
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 ?
This is wrong way can explain with an example what you want to achieve this is not understandable.
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 ?
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>