Erroneous records in datafeed; values offset incorrectly | Community
Skip to main content
J
jdosch
January 23, 2024
Question

Erroneous records in datafeed; values offset incorrectly

  • January 23, 2024
  • 1 reply
  • 409 views

I'm running a datafeed into Amazon S3 and am trying to run a parameter in one of the variables (Visit Number); I'm seeing a Page Name value in a numeric field (evar) and in the Time Stamp field I'm seeing text from another field as well.  Has anyone run into this?  Do you just exclude these anomalies? Or, is there a way to get to the root cause and troubleshoot to prevent further fields from needing to be excluded as the data base grows; potentially these anomalies COULD be symptoms of a bigger issue?

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

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
January 23, 2024

I suspect that whichever delimiter your file is using, that character appeared in one of the values in that row, causing items to shift columns?

 

For instance, maybe the file is "tab" delimited.. so each tab indicates a new column, but maybe you had a value in a field like eVar1 = "something \t value" (\t being a tab)... so "something" ended up in eVar1 and "value" ended up in eVar2, the value of eVar3 was pushed to eVar4, etc....

Terms & ConditionsAccessibility statement

Loading footer...