Uploading an empty field (column) from a database in audience manager | Community
Skip to main content
R
rafaelb
Level 2
April 19, 2021
Solved

Uploading an empty field (column) from a database in audience manager

  • April 19, 2021
  • 2 replies
  • 2731 views

Hi Everyone,

 

We are about to do an integration from our first party data source with AAM, to avoid any future data reprocess, we would like to include all the fields in the scope, including several calculated fields. Given this calculated fields are not available yet, is it possible to include the columns for these fields associated to a client ID with a default value and then populate them when we have said variables available?. Here's an example of how we are hoping to upload the data.

 

Client ID         Ordered Items          CLV

123                           1                    Default Value

1234                         4                    Default Value

12345                       5                    Default Value

 

Thanks!

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 Varun_Kalra

Hi Rafael,

 

Certainly you can do that. You could either leave the value as empty in the file or can use a default value for no availability of values in the meantime. Both of the following examples will work:

 

12345 ordered_items="5",clv="",ordered_product="abc"
12345 ordered_items="5",clv="null",ordered_product="abc"

 

In the first example the value is blank and in second one the value is a default string "null" or you could use any string like: "na" etc.

 

Thanks,

Varun Kalra

2 replies

Varun_Kalra
Varun_KalraAccepted solution
Level 9
April 22, 2021

Hi Rafael,

 

Certainly you can do that. You could either leave the value as empty in the file or can use a default value for no availability of values in the meantime. Both of the following examples will work:

 

12345 ordered_items="5",clv="",ordered_product="abc"
12345 ordered_items="5",clv="null",ordered_product="abc"

 

In the first example the value is blank and in second one the value is a default string "null" or you could use any string like: "na" etc.

 

Thanks,

Varun Kalra

    A
    arturradukevic453
    May 6, 2021
    Hello, please tell me how can I use the default option? don't quite understand ... thanks for the help in advance
Regards Artur employee tracking

     

    Terms & ConditionsAccessibility statement

    Loading footer...