Classifications from data layer | Community
Skip to main content
David_Jerome
David_Jerome
Level 6
January 9, 2020
Solved

Classifications from data layer

  • January 9, 2020
  • 1 reply
  • 2836 views

Hi there,

 

I am going to assume it's no but I thought I would check will others here first.

 

We have a some evars that have saint classifications for them, so for example evar1 might be "LAX" and there is a classification which changes this to "Los Angeles International Airport". Historically these uploads have been done manually and are a huge pain, however recently this data has been made available to us in the data layer.

 

I am aware that I could change the structure of the data from "LAX" to "LAX|Los Angeles International Airport" however I fear doing this will mess up trended / historical data.

 

One work around I have thought of would be to create a new classification based on the original value but this seems quite convoluted. Does anybody know if there of passing classification values another way?

 

Thanks


Dave

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 fsakjlfdsakljfd

If the airport value is now available within the data layer, does that relationship also exist in a data warehouse you can access via sql?

We have a lot of workflows where we automate the export of eVars in which a classified value does not exist, run those values through sql, and then using FTP push back up to Adobe.

Another option would be to store the full name in a different eVar and then export the correlated eVar values to then upload back into the classification.

1 reply

fsakjlfdsakljfd
fsakjlfdsakljfdAccepted solution
Level 5
January 9, 2020

If the airport value is now available within the data layer, does that relationship also exist in a data warehouse you can access via sql?

We have a lot of workflows where we automate the export of eVars in which a classified value does not exist, run those values through sql, and then using FTP push back up to Adobe.

Another option would be to store the full name in a different eVar and then export the correlated eVar values to then upload back into the classification.

Terms & ConditionsAccessibility statement

Loading footer...