Data Lost when split column and filter with needed values

[GabConstenla]

Hello!

I have a dataset with 10 columns but 3 of those (EVT_INV, EVT_INS, EVT_ASI) are in format "Value1; Vaue2; Value3, Etc". EVT_INV is for Invited Events, it's the most important of those. For testing, I only split EVT_INV for the count quantity of rows the result was 79.256 Rows so,  that number of rows is the number of invited people. When I split and filter the other 2 columns with values that I need and count them, there's only 77094, meaning that the dataset lost 2000 rows approx.

For Comprehension, when columns EVT_INS, EVT_ASI doesn't match with the Information of EVT_INV and the value is NULL or BLANK I replaced with "No Especifica" because I need the information of EVT_ASI, so if I filter I consider "No Especifica" in the parameters too, or the data about EVT_INV with no matches, will lose. I have done an example of the dataset that I use because the data is confidential, but the numbers of rows and codes of those 3 columns are the same. The sheet "Resultado Esperado" means "Expected Result" which is the result that I think is correct because I only split EVT_INV column and count its rows, and "Resultado Obtenido" means "Obtained Result".

Thanks in advance!

[v-kelly-msft]

Hi  @GabConstenla ,

I dont know whether there's some problem.when I checked your dataset,it shows the total rows is 24956:

If it's part of your data,what transformation do you wanna do and how many rows do you expect to get?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!