Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

targetData in a direct delivery template

Avatar

Avatar
Validate 1
Level 1
manuelcantillo
Level 1

Likes

0 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
manuelcantillo
Level 1

Likes

0 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
manuelcantillo
Level 1

22-01-2021

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:

manuelcantillo_0-1611327710859.png

targetData:

 

manuelcantillo_1-1611327780524.png

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

 

 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

166 likes

Total Posts

383 posts

Correct Reply

135 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

166 likes

Total Posts

383 posts

Correct Reply

135 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile
Milan_Vucetic
MVP

25-01-2021

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

 

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 1
manuelcantillo
Level 1

Likes

0 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
manuelcantillo
Level 1

Likes

0 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
manuelcantillo
Level 1

25-01-2021

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