How do i script to select only the first record of the first dimension when other two dimensions can make record unique
i have a file with 200k records and multiple fields (see attached item master QVD) and want to load only three fields below
[Part number]
[Item Status]
[Commodity Code]
My desired result is, part number sorted ascending, status sorted ascending and commodity code
but i only want to select the first record for each part number.
My output will only have one part number, the first status code associated with that part number and the commodity code associated with that part number.
below is desired result
Part Number
Item Status
Commodity Code
6551-246
1
093
However there can be many status combinations and commodity code combinations for One Part number. Although there can be many combinations for one part number i am only concerend with the selecting the first record of a part number once each of the above three fields have been sorted ascending.
I have tried to load my QVD, sort the above three fields ascending and then isolate the resident table but need some help as i am still very new to Qlikveiw. Previously i dont think that i clarified my question.
Attached is my QVW and my Item Master QVD
the below is are the current results that i am getting
Part Number
Item Status
Commodity Code
6551-246
1
093
6551-246
4
OBP
6551-246
4
093
or
Part Number
Item Status
Commodity Code
6551-246
1
093
6551-246
4
OBP
as you can see my current results would be fine if i wanted all combinations for each part but i want to select only the first record regardless of all possible combinations, if the three fileds are sorted ascending then by selecting the first record for each part, i will achieve my desired output
