Filter field based on another field in load

[sibideepak]

Hi all,

I want to filter one field based on another field..ex:

Load * inline [

Field1,Field2

A,1

B,1

C,1

D,1

E,2

F,2

G,3

H,3

];

This is just example ..I have huge data set .. What I want to filter is for each Field2 I need First 3 or more Field1 values.

[#2]

Hi Deepak,

not sure I follow what you are after, by selecting '1' in Field 2 in your example, you will naturally filter to the possible values of Field1 ABC.

So in the load a where clause on field 2 of that value would limit the data to just those 3 values.

Can you explain in more detail what you are looking to do

thanks

Joe

[sibideepak]

Hi ,

Thanks for response ,

For Each Distinct Field2 I need first 100 records in Field1.

[arulsettu]

hi try this

          first 100 load distinct Field2 ,

                                        Field1

                    from....