targetData in a direct delivery template

[manuelcantillo]

Hello.

I am facing a problem when creating a direct delivery template.
I want to add some columns to the extraction file and collect this values from the targetData.

Here is a part of the extraction file:

Output columns: (notice they have alias assigned:

targetData:

What I want to accomplish is that the targetData value goes to the output column without the need of assigned manually.

I was hoping that if I create a query and add some extra fields and assigned a alias per field, this fields will auto added to the output columns (from the extraction file) without the need to assigned manually.

Hope someone can help me out.

Thanks

[Milan_Vucetic · Accepted solution]

Hi @manuelcantillo 

you have defined these columns with empty value inside. You cannot expect to be overwriten.

Instead, if you are sure these columns are always there just select them as other columns in output.

Regards,

Milan

[manuelcantillo]

Is there a way to put a default value if the column does not exists?

[manuelcantillo]

Is there a way to put a default value if the column does not exists? or Do I need to create it like: IsEmptyString([targetData/@test],'' ,[targetData/@test] ) ?

[Milan_Vucetic]

Hi @manuelcantilo, you can define [targetData/@test] in delivery but I think delivery will fail if this column is not provided. You should test it anyway. You can create two deliveries (one with this field and another without) with one test node in front of them. So in case column exist/does not exist to point to respective delivery in order to avoid delivery failure. Regards, Milan

[manuelcantillo]

Is there a way to put a default value if the column does not exists? or Do I need to create it like:

IsEmptyString(NoNull([targetData/@test]),'',[targetData/@test] ) ?

Thanks