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

awijaya
Community profile awijaya Level 1
Job title here
Location here
3 BADGES
Level 1

Level 1

Learn more
Joined the community 03-03-2020 12:07:47 PM
Offline
Top badges earned by awijaya
Customize the badges you want to showcase on your profile
Re: Controlling WKF table field length
Avatar
Give Back
Level 1
awijaya
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
Validate 1
View profile
awijaya
- Adobe Campaign Classic
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.1K

Likes

0

Replies

0
Re: Controlling WKF table field length
Avatar
Give Back
Level 1
awijaya
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
Validate 1
View profile
awijaya
- Adobe Campaign Classic
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.2K

Likes

0

Replies

0
Controlling WKF table field length
Avatar
Give Back
Level 1
awijaya
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
Validate 1
View profile
awijaya
- Adobe Campaign Classic
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.2K

Likes

0

Replies

4