Adding distinct value to each CSV file given my code

Question

Hello.
I have the following code which seperates my Records.CSV files to two different CSV files based on COMPID (-> a key given in a dictionary I created):
(the first 3 files): records -> sepereated into two above :

anyways, I need to count each compId individually(basically each file) for the number of rows and add it distinctly like the following:

and this is my function:

now my problem is, that I cant distinct each file to get its own length, as showed in red ( in the code ), the top line will be the same in each CSV.
how can I achieve two different lengths for two different files, given the solution I already have?
thanks!

Answer 1

Hi @gal mor ,
Since the data is read row by row, you can set two variables to count the number of rows of data added to each file.

            string compId1 = "aa";  
            string compId2 = "bb";  
            Dictionary<string, int> dic = new Dictionary<string, int>();  
            dic.Add(compId1, 0);  
            dic.Add(compId2, 0);  
  
            dic[compId]++;//After readLine every time.  

Best Regards.
Jiachen Li

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.