Forum Discussion
Filter Function or any Logic
Dear Experts,
I have a data like below , Column "H" has rnti's , Column "F" has sfn which can range from 0~1023( and once 1023 it shall start again from 0) slots that can range from 0~9, each sfn(say 252) has slots(0~9),
Column "J" is Sn( Sequence number) ,
In Output , I want like this, example for the rnti 384, column "B" = count of spdu-1 for the rnti=384, and so on
How the spdu-1 counted? (spdu-x's are counted per rnti & per-rlcCtrlAckSn_ ,) as below for example for rnti==384,
Thanks in Advance,
I posted this earlier also , not sure why post got deleted somehow
19 Replies
From what I understood - not sure at all...
With Power Query
Sample avail. at:
https://1drv.ms/x/c/1cd824d35610aacb/EfPfZVpT0PpAoPnQGXSlcB8B6CqgBFaiUCAIwG4Q9QJg-A?e=mkIePj
Does the M code in the sample file return the intended output? I've created sample data since i don't have access to your file.
No OliverScheurich , the data also we need to calculate, attached is the sheet again, Worksheet home is the actual data,
1st Col-K we need to calculate for each rnti:-
As an example, I just created a sheet for rnti==9400, and created the data for it(Col-K and M)
then output like below can be easily be populated
which , I need for all rnti's in the home tab.
I've found your sample file in an earlier thread. However there is only one rnti in your sample file that is 384. I've attached your sample file "Filter_Function.xlsx" with suggested code.
For my sample data there are now 2 queries as shown in the screenshot. One query returns the final output and the other query shows the intermediary step that includes the "spdu-" column. My sample file is "Filter Function or any Logic.xlsx".
Attachment
unfortunately the attachment is not present.
it is also unclear how the counting is supposed to work.
(spdu-x's are counted per rnti & per-rlcCtrlAckSn_ ,)
If you are just counting spdu-x from 1 to x where x is the total number of items with the same rnti & per-rlcCtrlAckSn_ then what is supposed to go into that table? If the value in the table is supposed to be the count of spdu-1 that occur then how is the 1 or 2 or .... determined? is that based on the slot #?
I just notice the last column shows "spdu>7" so that column should count all the spdu's >=7?
Here's the Attachment m_tarler , so if the same rlcCtrlAckSn_ is repeated twice then spdu-1, if repeated 3 times then spdu-2 and so on.. for the same RNTI and same rlcCtrlAckSn_
