Cannot Convert Datatable to IEnumerable error!

Hi Guys, i am working on a DU Project and getting this error at the end when i am using For each Loop.

Scenario:- Using Performer ReFramework using DU i have to process 3 pdfs, and store the data in an excel file, when doing so i can only print the last excel file data, so i used a build data table in init state and then used merge data table activity to merge the export dataset and my init datatable at for each its giving ,

Need Help!


Tried this as well but in vain

@Anil_G @supermanPunch

Hi,

It’s unnecessary to use ForEach activity.
Can you try to set in_MainDt in WriteRange activity directly?

Regards,

@Jai_Pande

You just need to use in_Maindt in the write range without the for loop

Cheers

HI @Anil_G i want to use the all four tables(simple fields and line items as well) of dataset tables so thats why printing them with for each

Hi @Yoichi

I need to print simple fields and line items as well from each pdf

Hi,

Is Dataset Dataset type variable? How about set Dataset.Tables in ForEach as the following?

Regards,

@Yoichi i have already used that in merge data table, kindly help

@Jai_Pande

You are daying you merged the data alredy…the output would be datatable only…again you are saying simple. And table feilds can you please elaborate proeprly

Cheers

@Anil_G
I need to extract all the 4 sheets(simple and items) out of one pdf…when i am not using build data table and mergef its only extracting the last pdf in the processing

@Jai_Pande

So you used a merge so already all data should have been merged into single table so directly use that table…

Fyi- And merge will create the achema already so build is also no needed

Cheers

@Anil_G okay but i have used merged in conjunction with build brother! Ah! Getting a bit confused. Previously i have worked on projects this method was working…but in reframework its throwing this error kindly help i am really stuck

@Jai_Pande

What is the error you are getting and what you tried

cheers

@Anil_G request you to kindly in teams for 5 mins and help me resolve it. I am really stuck…should i send link here brother

@Anil_G Can you please come ?

@supermanPunch @postwick @ppr

@Anil_G Cannot convert datatable to ienumerable error

Purchase_Performer_DU.zip (35.8 KB)

I have tried this now also getting the same error @Anil_G @supermanPunch

Validation mark is reasonable:

here a single datatable (the first one from the dataset) is sent to the for each.

Loop over all tables:

or use

Kindly note:
it was also ealier mentioned by others: