looping over inputfiles to get fieldnames

[Mikis]

Hello everyone,

Once again a very basic question (sorry).

I have a number of SPSS files for which I want a list of the fields.

Let's say there are 2 files where the first one has field A, B, C and the second has B, D, E then my result would be

file	field
1	A
1	B
1	C
2	B
2	D
2	E

I wrote a very simple batch macro for this (cf below & attached). I think it gives a good idea of what I'm trying to achieve.

However, I'm not really sure how to fuel it.

Could someone please give a helping hand?

Thanks,

Mikis

[Claje · Accepted solution]

Hi,

I attached an updated version of this batch macro here.  Roughly, I think you were super close to what you wanted, but in batch macros, the macro runs once for each line/set of data input.  Therefore, the easiest way to do this would be to use the Input Data tool.

Then, you can use this macro with a Directory tool beforehand to pull in all of your files that you want to see info for.

Let me know if this helps!

[Mikis]

@Claje

Thanks, that helped a lot.

I had some issues with updating the fileName because I was apparantly using single quotes instead of double ones and that gave issues with replacing them.

I added the final workflow package for others, thanks a lot for your support!