Tool #179: There were no common fields

[8802036946]

I have created a batch macro which converts csv into excel for different database files.

I am getting an error in macro for union tool- which states that : There is no common fields.

Any solutions would be highly appreciated.

Thanks

[PanPP]

Hi @8802036946 

The columns that are being processed by the macro, are they all the same format, same names, etc?

Maybe you can try the configuration below?

Hope this helps.

[ShankerV]

Hi @8802036946 

I believe you have created a macro, assuming each time you will have Column names as A, B, C.

And did a union based on existing column names.

Now when you try to input, columns X, Y, Z

then the union tool with matching criteria gets greyed out for A(not found).

Which throws an error where there is no common field to proceed union.

Please do check from that perspective.

Many thanks

Shanker V