Level 6

Solved

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

Forum|Forum|2 years ago
September 20, 2023
7 replies
2200 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by ParthaSarathy

@god_prophet , 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.

Hi @god_prophet ,

The solution for this is given in another thread.

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/the-year-field-with-value-2023-05-12-in-2023-05-12-18-09-07/td-p/621250

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.

ParthaSarathy

Community Advisor

Hi @god_prophet ,

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.

~ ParthaSarathy S~ Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups

G

god_prophetAuthor

Level 6

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

ParthaSarathy

Accepted solution

Community Advisor

@god_prophet , 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.

Hi @god_prophet ,

The solution for this is given in another thread.

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/the-year-field-with-value-2023-05-12-in-2023-05-12-18-09-07/td-p/621250

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.

~ ParthaSarathy S~ Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups

Manoj_Kumar

Community Advisor

Hello @god_prophet

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

Manoj Find me on LinkedIn

G

god_prophetAuthor

Level 6

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

Krishnanunni

Level 4

@god_prophet
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

Community Advisor

@god_prophet
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

David Kangni

G

god_prophetAuthor

Level 6

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

LakshmiPravallika

Community Advisor

Hi @god_prophet ,

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

Community Advisor

Hello @god_prophet,

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

Amine ABEDOUR

Sukrity_Wadhwa

Community Manager

Hi @god_prophet,

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!

Sukrity Wadhwa

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded