Macro issue to input xml files with different schema

[daophuongtrinh]

Hello everyone,

I intend to build a macro to loop the full path of xml files and then input it into workflow. But the macro only returns one file only, I was unable to find the problem with this macro.

Here I have 4 xml files with different schema, I use Directory to get the paths, and make macro to loop those paths.

This is the output of Directory:

This is the output of Macro:

I expect to have 4 records out from Macro, but I was unable to find the issue. Please have a look at this in the attachment and share your idea with me 🙂

Thank you in advance.

Best,

Trinh

[grazitti_sapna · Accepted solution]

Hi @daophuongtrinh , I have made some changes in your macro give this a try.

Configuration

Attaching the macro along just you need to change the path in the macro where I have mentioned

Result-

Attaching a workflow along.

Thanks.

[daophuongtrinh]

Dear @grazitti_sapna 

Thank you very much for your solution, however when I change the path the result still returns 1 file only. Could you confirm that I have changed these paths right?

I have changed:

1. The path in Text input

2. The path in Dynamic input:

Here is my result:

[grazitti_sapna]

@daophuongtrinh  try saving the macro and insert in the workflow again. 

This is my result.

Let me send you the file again with modification in the name maybe the macro is still your older macro in the workflow.

Try this and follow the same procedure as told earlier.

Thanks.

[daophuongtrinh]

I have tried several times but it still returns the same 1 result 😞

Could you please have a look at my workflow as well?

[grazitti_sapna]

Hi @daophuongtrinh , can you create a yxzp file and then send it? I am not able to access the macro also I do not have access to your directory so I can test on my path only.

Thanks.

[daophuongtrinh]

Dear @grazitti_sapna, please find the package and macro in the attachment.

Thank you very much!

[grazitti_sapna]

HI @daophuongtrinh , try passing the location of a file in text input and dynamic input tool as shown in the image below.

attaching the macro and workflow below.

Thanks.

[daophuongtrinh]

Dear @grazitti_sapna ,

I just delete and enter, unclick and click and save and close and open, and now it works with just the original solution :))

I can't tell why but thank you very muchhhhh!!!

[grazitti_sapna]

@daophuongtrinh , I am glad it finally worked for you. Have a great weekend ahead.

Thanks.