Expand my Community achievements bar.

SOLVED

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

Avatar

Level 5

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. 

ogonzalesdiaz_1-1695224025189.png                        ogonzalesdiaz_0-1695223947524.png

 

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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.

ParthaSarathy_0-1695729934524.png

 

Enrichment:

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

ToDateTime(date_creation)

ParthaSarathy_1-1695729970872.png

 

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

ParthaSarathy_2-1695729993582.png

 

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

 

View solution in original post

14 Replies

Avatar

Community Advisor

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. 

ParthaSarathy_0-1695225495436.png

 

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

Avatar

Level 5

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

ogonzalesdiaz_0-1695238891567.png

 

Avatar

Community Advisor

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

ParthaSarathy_0-1695314642283.png

 

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.

ParthaSarathy_1-1695314734303.png

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. 

Avatar

Level 5

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

ogonzalesdiaz_1-1695316198008.png

 



ogonzalesdiaz_0-1695316150067.png

 

Avatar

Community Advisor

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

Avatar

Correct answer by
Community Advisor

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.

ParthaSarathy_0-1695729934524.png

 

Enrichment:

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

ToDateTime(date_creation)

ParthaSarathy_1-1695729970872.png

 

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

ParthaSarathy_2-1695729993582.png

 

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

 

Avatar

Community Advisor

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?


     Manoj
     Find me on LinkedIn

Avatar

Level 5

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

Avatar

Level 4

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

Krishnanunni_0-1695303351728.png

 

Avatar

Community Advisor

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

 

DavidKangni_0-1695306949154.png

Thanks,

David



David Kangni

Avatar

Level 5

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

ogonzalesdiaz_0-1695313781198.png

 

Avatar

Community Advisor

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.

Avatar

Community Advisor

Hello @ogonzalesdiaz,

 

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

Amine_Abedour_0-1695545916575.png

 

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

 

Avatar

Administrator

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!



Sukrity Wadhwa