summarize input table

[welchs101]

I am enclosing a file to help identify the input file and the output desired.

Input file similar to cols A,B,C and D.
Output like that shown in cols L,M,N,O,P

I am not sure the best approach to get the desired output...open to suggestions.

if you need additional information or if i have confused you please let mknow.

[jindon]

Please Login or Register  to view this content.

[sintek]

Another option...

Please Login or Register  to view this content.

[welchs101]

what does this mean/do?

Please Login or Register  to view this content.

[welchs101]

jindon, found something else i wanted to ask you about

what does this do and does it have any limitations for "size" like if num of rows is large

Please Login or Register  to view this content.

[jindon]

I'm not with my pc, so my reply will be tomorrow.

[sintek]

Just out of interest...Did you try code in post 3...

[welchs101]

sintek, not yet but i plan to. thanks again.

[sintek]

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Thanks.gif

[welchs101]

Jindon,

I have another question regarding this step:

Please Login or Register  to view this content.

I looked at "w" before and after this assignment. "w" is a 5 element array where element 1 "w(1)" is the protocol and "w(2)" is a dictionary. Elements 3,4, and 5...
not sure what they are for.......but regardless.........how is it that when you say

Please Login or Register  to view this content.

that it knows to update not just the dictionary but also w(1) element of the protocol........i dont get it

what exactly is going on when you make this assignment. sorry to bother you but i just dont understand.

[jindon]

what does this mean/do?

Please Login or Register  to view this content.

Use like If function in a cell, see
https://docs.microsoft.com/en-us/off...p/iif-function

what does this do and does it have any limitations for "size" like if num of rows is large

Please Login or Register  to view this content.

It converts Jugged Array(arrays in an array) to 2D array when each element are 1D array with the same size.
Limitstions;
No element should not have more than 255 characters.
Number of Array should not exceed 65536, if I remember correctly.

If your actual data is like above, you will need to prepare another array for output.

Please Login or Register  to view this content.

I looked at "w" before and after this assignment. "w" is a 5 element array where element 1 "w(1)" is the protocol and "w(2)" is a dictionary. Elements 3,4, and 5...
not sure what they are for.......but regardless.........how is it that when you say

Please Login or Register  to view this content.

Because your output table has 5 columns, it should be so.
Each array, w, represents the line of output for unique "Protocol"
w(2) = sub-dictionary for counting its unique site and will be converted to its count later.

HTH

[welchs101]

jindon, this may be a stupid question but where/when do you assign the protocol to the parent dictionary? what line of code?

[jindon]

Please Login or Register  to view this content.

If you want, add a variable like dic and replace above line with

Please Login or Register  to view this content.

[welchs101]

thanks for the info....