Find Files with Missing Fields

I have a folder with > 1K .tab files and about 10% of them are missing two attributes (columns) which need to be added in order to not be skipped using the input tool. How would I find these files and add the missing attributes (columns)?

Thanks in advance,

Todd

Input

Preparation

Expression

Accepted answers

rohanonline

You can select the option to include filename from the input tool. Then summarize by filenames to see which files are included. Join them with the list of all files to find what is missing.

Input 2.JPG

All comments

MarqueeCrew

@TR,

Try this macro out (Union by Name + Type). It calls a batch macro (batch union). When you use it, you'll identify a template field map (what you think that you need). Next you'll give it a directory to start looking in (it will search all subdirectories). Give it a wildcard search term like "FindMe" as part of the filename. you can then specify a file type (tab) and it should read all of your data (even if there are missing columns). You'll get warnings for each of the files with missing data fields.

It is worth a try...

Mark

Batch Union.yxmc

Union by Name + Type.yxmc

rohanonline

You can select the option to include filename from the input tool. Then summarize by filenames to see which files are included. Join them with the list of all files to find what is missing.

Input 2.JPG

Thanks @rohanonline the join was the missing piece in my workflow as I was trying to solve this using both the input and browse tools separately. I only had to add an additional Formula tool to append the +".TAB" to the filename on the Input Tool to have it join and show me what files were missing. I grouped on filename and summed the missing field(s). I definitely had "workflow block" on figuring this out.

Much thanks!

Todd

Thanks @MarqueeCrew for the fast reply. I'm going to check out your workflows and save them for future use in my war chest. I was able to quickly add a join using the other proposed solution and figured it out. Have a great week!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703