Why the load activity would load 1 row less than total rows? 11 instead of 12.

[ogonzalesdiaz]

Even in the configuration of the Load activity the 12 rows are recognized, but after data is loaded, in Display target I see only 11. 

                        

[ParthaSarathy]

Hi @ogonzalesdiaz ,

From the screenshot in data loading activity's preview, there are 12 counts. These 12 counts are from the sample file you attached from your local computer.

But the 11 counts which are the result of data loading activity is from the actual file processed by the data loading activity. 

If you have permission to view the actual file, please cross check what is the count in that actual file. 

[ogonzalesdiaz]

Hi ParthaSarathy, is the same 12 rows in the original file that is been uploaded : 

[ParthaSarathy]

@ogonzalesdiaz , In data loading activity, enable 'Keep the rejects in a file'

Now you can able to see 'complement' transition.

Run the workflow and see whether you're able to see 11 records in 'Result' Transition and 1 record in 'Complement' Transition.

If you're able to see 1 record in complement, analyze the record why its get ignored in main transition.

If you still able to see 11 records in Result and 0 records in complement, try creating a new data loading activity in a new workflow and run again. If possible share the command which you had provided to 'pre-process the file'.

And you can also try 'upload a file from local machine' with the actual file, and see what is the count of the the transition. 

[ogonzalesdiaz]

When Keep the reject is activated, the workflow gives error: 

[ParthaSarathy]

@ogonzalesdiaz , It seems you don't have rights to place a file in the particular path. Try providing folder path where you have access.

Between, from your log screenshot, I can see it says in one of your record for one of the column  there is data mismatch (year is too long). Please cross check your data. 

So out of 12 records, 11 records has proper format for all column, and one row alone has incorrect formal.

[ParthaSarathy · Accepted solution]

Hi @ogonzalesdiaz ,

The solution for this is given in another thread. 

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/the-year-field-wit...

Have you got an opportunity to try it?  In data Loading activity, instead of defining it as date+time, define it as 'string'. So you will be getting all 12 records as output of 'Data loading' activity.

Now Connect data loading transition with enrichment activity.

Enrichment:

Add data > add an output column in it with below expression,

ToDateTime(date_creation)

Now the new field created in enrichment, will remove the millisecond.

And you can use this new field in your workflow for importing the data and for other purpose.

[_Manoj_Kumar_]

Hello @ogonzalesdiaz 

Can you check if there is any kind of data type mismatch and if there are any records going in the reject transition?

[ogonzalesdiaz]

Hi Manoj, where do you set the rejects transition? In the Load Activity?

[Krishnanunni]

@ogonzalesdiaz 
Check if there is a new line at end of last row in the file. If not, then the last line would be skipped. Expected is as follows.

[DavidKangni]

@ogonzalesdiaz 
You need to check your file loading how the errors are processed. Here is one example when email is mandatory in my flow.

Thanks,

David

[ogonzalesdiaz]

Hi David, they are all set to Ignore the value: 

[LakshmiPravallika]

Hi @ogonzalesdiaz ,

Please specify the path of the Rejects file with valid path, starting from "/sftp/..." or you can refer any of your existing workflows using File collector activity to know the right folder path in your server , and re run your workflow to check if any rejects are getting generated.

Regards,

Pravallika.

[Amine_Abedour]

Hello @ogonzalesdiaz,

Please check if the 'use first line as header' parameter is checked (sorry for the french screen shot):

If it is checked and your file does not have a header line, Adobe considers that the first data line is the header.

Br,

Amine

[Sukrity_Wadhwa]

Hi @ogonzalesdiaz,

Were you able to resolve this query with the help of the given solutions or do you still need more help here? Do let us know. In case the given solutions were helpful, then kindly choose the one that helped you the most as the 'Correct Reply'.
Thanks!