since ‎04-02-2020
‎18-10-2020
gowthamanrajendran
Level 1
What is the matching date type for Decimal in adobe campaign
Avatar

gowthamanrajendran

gowthamanrajendran
- Adobe Campaign Standard
I want to insert Decimal(15,2) values to adobe table, The data i sourced from teradata. i could not able create the column with decimal in adobe. what is the matching data type should i set to this column?

Views

236

Likes

0

Replies

1
Re: How do i get auto incremental key from my sequence?
Avatar

gowthamanrajendran

gowthamanrajendran
- Adobe Campaign Classic
Hi, I have autopk turned on but still its throwing error, i dont have my own column as primary key.

Views

2.8K

Likes

0

Replies

0
Re: How do i get auto incremental key from my sequence?
Avatar

gowthamanrajendran

gowthamanrajendran
- Adobe Campaign Classic
No i tried this. this is throwing another exception. missing from clause ....

Views

2.0K

Likes

0

Replies

0
How do i get auto incremental key from my sequence?
Avatar

gowthamanrajendran

gowthamanrajendran
- Adobe Campaign Classic
I am trying to execute insert operation throught javascript method. var temp="INSERT INTO gowSampleDB(sSTG_ID,sATTRB_CD,sATTRB_VAL) VALUES ('9383677898998939','GOWTHAMANTEST','GOWTHAMTEST1')";logInfo("My query :"+temp);var strSql = sqlExec(temp); but its throwing unique constraint exception. How do i refer to my sequence and get the next value to insert? 02/11/2020 12:50:57 PM WDB-200001 SQL statement 'INSERT INTO gowSampleDB(sSTG_ID,sATTRB_CD,sATTRB_VAL) VALUES ('9383677898998939','GOWTHAMANTES...

Views

3.8K

Likes

0

Replies

5
Re: How do i select values from enrichment to insert them...
Avatar

gowthamanrajendran

gowthamanrajendran
- Adobe Campaign Classic
I want to invert the table which i am getting from enrichment. So is there any other way to do this with our SQL code activity? ID FirstName LastName Email1 Name1 Name12 Email12 Name2 Name22 Email23 Name3 Name32 Email3 i want to convert above table into ID AttributeName AttributeValue1 FirstName Name11 LastName Name121 Email Email12 FirstName Name22 LastName Name222 Email Email2

Views

1.7K

Likes

0

Replies

0
How do i select values from enrichment to insert them into table using SQL code activity
Avatar

gowthamanrajendran

gowthamanrajendran
- Adobe Campaign Classic
Hi , I am using SQL code activity to do insert into custom table . From the the below code i want the data from enrichment before sql code activity. Can some one give me sample query to fetch values from enrichment and insert into table. INSERT INTO Customtable(column1, column2, column3, ...)SELECT column1(From enrichment), column2, column3(From enrichment), ...FROM enrichment.

Views

1.7K

Likes

0

Replies

2
Re: How to add insert data which is populated from enrinc...
Avatar

gowthamanrajendran

gowthamanrajendran
- Adobe Campaign Classic
I don't know how to use SQL activity for this. Any idea?

Views

2.3K

Likes

0

Replies

0
Re: How to add insert data which is populated from enrinc...
Avatar

gowthamanrajendran

gowthamanrajendran
- Adobe Campaign Classic
ID FirstName LastName Email1 Name1 Name12 Email12 Name2 Name22 Email23 Name3 Name32 Email3 i want to convert above table into ID AttributeName AttributeValue1 FirstName Name11 LastName Name121 Email Email12 FirstName Name22 LastName Name222 Email Email2

Views

2.3K

Likes

0

Replies

0
Re: How to add insert data which is populated from enrinc...
Avatar

gowthamanrajendran

gowthamanrajendran
- Adobe Campaign Classic
Appreciate it.

Views

1.7K

Likes

0

Replies

0
How to add insert data which is populated from enrinchment?
Avatar

gowthamanrajendran

gowthamanrajendran
- Adobe Campaign Classic
Hi, I have enrichment with all the data i want. Now i am trying to insert into table through java script. I dont want to use update sql activity due to some table transformation. How do i derive the data which populated in enrichment in java script. For ex sqlExec("insert into gow:SampleDB(std_id,name) select std_id, name from vars.targetSchema"); i want std_id and name from enrichment table.

Views

3.3K

Likes

0

Replies

6
Re: How can i transpose this table?
Avatar

gowthamanrajendran

gowthamanrajendran
- Adobe Campaign Classic
Appreciate it. I am trying to do this with workflow. Anyway to do this with workflow enrichment?

Views

1.6K

Likes

0

Replies

0
How can i transpose this table?
Avatar

gowthamanrajendran

gowthamanrajendran
- Adobe Campaign Classic
ID FirstName LastName Email1 Name1 Name12 Email12 Name2 Name22 Email23 Name3 Name32 Email3 i want to convert above table into ID AttributeName AttributeValue1 FirstName Name11 LastName Name121 Email Email12 FirstName Name22 LastName Name222 Email Email2

Views

1.6K

Likes

0

Replies

3
Likes given to