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.
1 Accepted Solution
Correct answer by
Hi @god_prophet ,
The solution for this is given in another thread.
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.
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.
@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.
@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.
Correct answer by
Hi @god_prophet ,
The solution for this is given in another thread.
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.
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?
@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.
@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
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
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
