Data Filters

[NiranjanK1]

Hi All, 

i have one excel sheet with column username, under username multiple users listed. If I run workflow data has to filter based on username, filtered data should be saved under respective username folders.

if folder is missing on user name we have to give message, no folder found on username.

how can Ido this logic.

thanks In advance 

niranjan

[acotta17]

Hi @NiranjanK1 ,

One way to approach this would be to use the Output Data tool with the "Append Suffix to File/Table Name" option, selecting the username field. This will dynamically generate a separate file for each user, consolidating all records associated with that username into a single file.

After the files are created, you can run a second process using a Directory Tool to access the generated files. Then, use a Find Replace Tool to match each expected username against the created files and identify any missing outputs.

I've attached a sample workflow for your reference. Let me know if this approach works for you!

Best regards,
Alicia