Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I have following data i want to create groups like name,address,salary in load script how I can do this ?
GROUPS | NAME | ADDRESS | SALARY | |||||
FIELDS | NAME | CITY | STATE | COUNTRY | REGION | BASIC | DA | HRA |
Thanks
Vikas
use the Group by function
Table1:
load
Field1,
Field2,
sum(Value1),
sum(Value2)
from ...
Group by Field1, Field2
You Need to define every field in the Group by clause and you Need to use a functtion like sum, max etc. for each value
Hi,
Here is the example :-
LOAD * INLINE [
BOOKID, TITLE, AUTHOR, PAGES, COUNTRY, QUANTITY
B001, Harry Poteh! Book 1, JK, 800, UK, 18
B002, Harry Poteh! Book 2, JK, 900, UK, 49
B003, Harry Poteh! Book 3, JK, 902, UK, 26
B004, Harry Poteh! Book 4, JK, 899, UK, 15
B005, Harry Poteh! Book 5, JK, 901, UK, 11
B006, Harry Poteh! Book 6, JK, 800, UK, 25
B007, Harry Poteh! Book 7, JK, 789, UK, 31
B008, Harry Poteh! Book 8, JK, 678, UK, 50
B009, Harry Poteh! Book 9, JK, 876, UK, 35
B010, Harry Poteh! Book 0, JK, 901, UK, 22
B011, Harry Hudin! Book 1, MA, 844, SG, 49
B012, Harry Hudin! Book 2, MA, 801, SG, 32
B013, Harry Hudin! Book 3, MA, 902, SG, 48
B014, Harry Hudin! Book 4, MA, 816, SG, 31
B015, Harry Hudin! Book 5, MA, 918, SG, 49
B016, Harry Hudin! Book 6, MA, 909, SG, 21
B017, Harry Hudin! Book 7, MA, 821, SG, 24
B018, Harry Hudin! Book 8, MA, 831, SG, 21
B019, Harry Hudin! Book 9, MA, 958, SG, 25
B020, Harry Hudin! Book 0, MA, 838, SG, 42
];
load * INLINE [
DIMENSION
BOOKID
TITLE
AUTHOR
PAGES
COUNTRY
];
Hope this helps.
Thanks,
Bunny
NOT CLEAR PLEASE CAN YOU GIVE EXAMPLE ?
Hi,
Check the attached app .
i think this helps.
Thanks , !
Bunny