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
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
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.