Data Missing after Dynamic Input and normal input

Question

Hello,

I have certain data that is missing from the input - even when run through dynamic and normal input. I've attached a mock data source, and below is a snippet of my workflow. The data below the "Description" column starting on line 34 is not posting, but everything else seems to be when running the workflow.

Can someone please assist?

Mock data source.xlsx

Christine_Assaad · Answer

Hi @mattpeltcfa

For the Dynamic input to loop thru your Excel files/sheets they must share the same schema in terms of headers, data types,..etc. If the schema is different, the dynamic input will skip the unmatching file/sheet.

To overcome this, you can either create a batch macro - if you have many files/sheets to loop thru Or you can use the Union building block to stack the data sets.

Hope this is helpful.. Cheers!

Maskell_Rascal · Answer

Hi @mattpeltcfa

Based on the mock data you provided, I can't recreate the issue you are having. I did notice that your mock data had two different tabs. Are you experiencing experiencing the problem on both tabs or one in particular?

Thanks!

Phil