How to count the number of columns in a file

[mahbs]

Hi,

I'm trying to do a comparison, wherein I want to verify that the number of columns in file X matches the number of columns in file Y.

Its literally a comparison of two figures.

Does anyone have any idea? I was thinking of using fieldsummary, but I'm not quite sure on how to implement it

Thanks

[cmerriman]

Are these indexes or lookups?

At any rate, to do it for one, you’d use something like ...|fieldsummary |stats count as fields And you can join or append the other file

[mayurr98]

Can you please elaborate your question?
Give us sample input data and tell us the output you want so that I can write a query for you.