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?
temp="INSERT INTO gowSampleDB(sSTG_ID,sATTRB_CD,sATTRB_VAL) VALUES
:"+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
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
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.
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.