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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

awijaya
awijaya
Offline

Badges

Badges
3

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
0

Posts & Comments

Posts & Comments
3

Discussions

Discussions
0

Questions

Questions
1

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by awijaya
Customize the badges you want to showcase on your profile
Re: Controlling WKF table field length - Adobe Campaign 05-03-2020
Seems like Edit Schema is just editing the temporary schema (WKF). Just like editing schema source in configuration, but instead it's on the fly. So, an expression field can be added to the WKF to be used further downstream. Since it is just an expression to the temp schema, it doesn't create a database column and no data being written. In my impression, WKF creation of an enrichment should factor in at least the largest column size involved in the formula/expression. This is not ideal, but mayb...

Views

2.4K

Likes

0

Replies

0
Re: Controlling WKF table field length - Adobe Campaign 03-03-2020
Hi Jon,These are really thoughtful answer. Thank you for that.I ended up using Edit Schema activity to create the expression. Btw, how do you find those undocumented js functions? I tried to look them up under Configuration > JavaScript codes, but they are not there.Thanks,- Alwi

Views

2.4K

Likes

0

Replies

0
Controlling WKF table field length - Adobe Campaign 03-03-2020
I have a schema with a string field of length 2100.In enrichment, an expression field is added which does a substring of that field such as this: Substring(@recommendation, 101, Length(@recommendation)-100) This is the error I get:03/03/2020 12:01:29 PM enrich PostgreSQL error: ERROR: value too long for type character varying(255) Which mean the WKF field is created with length of 255, while the source of that expression field is much longer than that. Is there a way to define the length for the...

Views

2.4K

Likes

0

Replies

4