Why the load activity would load 1 row less than total rows? 11 instead of 12. | Community
Skip to main content
god_prophet
Level 6
September 20, 2023
Solved

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

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.
ParthaSarathy
ParthaSarathyAccepted solution
New Participant
September 26, 2023

@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
View reply

14 replies

Sukrity_Wadhwa
Sukrity_Wadhwa
Employee
October 31, 2023

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!

Translate
Sukrity Wadhwa
Amine_Abedour
Amine_Abedour
New Participant
September 24, 2023

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

 

Translate
Amine ABEDOUR
LakshmiPravallika
LakshmiPravallika
New Participant
September 22, 2023

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.

Translate
DavidKangni
DavidKangni
New Participant
September 21, 2023

@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

Translate
David Kangni
god_prophetAuthor
Level 6
September 21, 2023

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

 

Translate
Krishnanunni
Krishnanunni
Level 4
September 21, 2023

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

 

Translate
_Manoj_Kumar_
_Manoj_Kumar_
New Participant
September 20, 2023

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?

Translate
     Manoj     Find me on LinkedIn
god_prophetAuthor
Level 6
September 21, 2023

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

Translate
ParthaSarathy
ParthaSarathy
New Participant
September 20, 2023

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. 

Translate
 ~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
god_prophetAuthor
Level 6
September 20, 2023

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

 

Translate
ParthaSarathy
ParthaSarathy
New Participant
September 21, 2023

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

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

Loading footer...