Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have filed
Sal
100
200
300
here i want to find the of 300 sal in sal table
Lookup() may be helpful, though it's (still) a script-only function.
Like in:
RawData:
LOAD RowNo() AS RNo, Sal INLINE [
Sal
100
200
300
];
LET vIndex = Lookup('RNo', 'Sal', 300);
If you want to use this value in the User Interface, can you provide us a few more details about what you are up to?
Peter
HI,
here i want to find the of 300 sal in sal table - what it means
means index location of 300
i used index(sal,300) butt return 0 when i used index(sal,100) return 1 ?
It will return 1 every time with not index value because it is
Check with this if you load you can find 4 and 7 because it is this locations
LOAD Sal,
Index(Sal,200) as Index200,
Index(Sal,300) as Index300;
LOAD * Inline
[
Sal
100200300
];
Regards
Anand
Hi hammad, maybe FieldIndex('Sal', 300), QV only stores different values so for a table like:
Sal
100 -->Index 1
200 -->Index 2
100 -->Index 1 (is a value previously loaded)
300 -->Index 3
The Index() funtion you are using to return the position where a substring starts in a string, ie:
Index('ABC', 'B') --> Returns '2'
Lookup() may be helpful, though it's (still) a script-only function.
Like in:
RawData:
LOAD RowNo() AS RNo, Sal INLINE [
Sal
100
200
300
];
LET vIndex = Lookup('RNo', 'Sal', 300);
If you want to use this value in the User Interface, can you provide us a few more details about what you are up to?
Peter
i think
it wont work
because u have to use only strings in index function .
ex:
index('apple','e') it returns 5