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

Anilr1717
Community profile Anilr1717 Level 1
Job title here
Location here
2 BADGES
Level 1

Level 1

Learn more
Joined the community 24-07-2020 2:59:42 AM
Offline
Top badges earned by Anilr1717
Customize the badges you want to showcase on your profile
Re: Transpose data adobe campaign classic
Avatar
Give Back
Level 1
Anilr1717
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Give Back
Shape 1
View profile
Anilr1717
- Adobe Campaign Classic
Hi,You can use enrichment activity to do the transpose of data(rows to column). Please follow below steps.Step1: Take the enrichment activity and make the self join with same table with the help of 1: N join while giving join condition.Step2: While adding the data please make sure to add column(No. of records to retrieve as per your convenience (By default it will be max 3 rows) ). So it will create multiple enrichment table based on your records to retrieve. If you have chosen 3 then it will cr...

Views

196

Likes

0

Replies

0
Date Format Function in Adobe Campaign Standard
Avatar
Give Back
Level 1
Anilr1717
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Give Back
Shape 1
View profile
Anilr1717
- Adobe Campaign Standard
Hi All, Putting some logic for Date Format function in Adobe Campaign Standard. ToDate(LPad(ToString(Month(GetDate())),2 ,'0' )+'/'+LPad(ToString(Day(GetDate())),2 ,'0' )+'/'+ ToString(Year(GetDate()))) ----MM/DD/YYYY (07/29/2020) Regards,Anil

Views

568

Likes

0

Replies

2
Re: Currency Decimal Places
Avatar
Give Back
Level 1
Anilr1717
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Give Back
Shape 1
View profile
Anilr1717
- Adobe LiveCycle
Hi, Just posting here so anybody can use it. 12345/1000 = 12.34 not 12.35 Code: 12.34 Floor(ToDouble(@CONTENT4)/1000)+'.'+Substring( Iif(Length(ToString(Mod(ToDouble(@CONTENT4), 1000)))<=1,LPad(ToString(Mod(ToDouble(@CONTENT4), 1000)),3 ,'00' ),Iif(Length(ToString(Mod(ToDouble(@CONTENT4), 1000)))=2,LPad(ToString(Mod(ToDouble(@CONTENT4), 1000)),3 ,'0' ),ToString(Mod(ToDouble(@CONTENT4), 1000)))),1,2 ) Code: 12.35 Round(ToDouble(12345)/1000,2) Regards,Anil

Views

194

Likes

0

Replies

0