How to remove whitespaces, tabs, and other elements that are not part of the content of the field?I've a column MES of the format: 202309 (for september of 2023) on format string in the schema and string in the configuration of the import activity.I want to remove whitespaces (tabs, etc) , in order ...

So this is a manual Campaign, it was a Start activity, not a Scheduler activity. So the idea is that user should be able to start the Campaign at anytime, run the queries and so on, but the delivery should arrive to user only between 8 am and 8 pm.So instead of: Iif( Hour(GetDate())<=8 , AddHours(To...

Hi ParthaSarathy, To get all records from LEAD schema, you just select the Targeting dimension and Filtering Dimension as LEAD, and click finish (without putting anything in Filtering conditions, right? 

We have this formula, it tries to contact Recipients between 8 am and 8 pm,  in this case it is set to 9 am.I'd like to make it directly, like: send this delivery the next day at 9 am. Or even better that the user the possibility to insert directly the date: 28/09/23 at 9 am. Iif( Hour(GetDate())<=8...

Actually, according to documentation TRUNCATE is better to delete all rows from a table. See: The  TRUNCATE TABLE statement deletes all data from a table without scanning it. This is the reason why it is faster than the DELETE statement.In addition, the TRUNCATE TABLE statement reclaims the storage ...

I have a table called: LEAD, with namespace: abc. I'm using V7 Classic.I've to remove all rows, since data is flawed and load new data. 1.- Create workflow that: Loads Table Lead:  with no filtering condition since I want to remove all rows from all columns, right? 2.- In a SQL Activity just use:  o...

I don't have a column Year on my data, but I think it is taken the year from my column: "date_creation". How can I remove the miliseconds from my column "date_creation" to avoid this warnings? Or Should I fix this in the source of the data? I get a csv file to upload to campaign. 

When Keep the reject is activated, the workflow gives error:   

Hi Lashmi, what about if I want to have both obtions: filter columns individually or both at the same time? Should I add this to the schema? Additionally of what I currently have.<dbindex name="CODCANALCOMU_CombinedIndex">   <keyfield xpath="@codinternocomputacional"/>    <keyfield xpath="@CODCANALC...

Hi, I'm doing indexing of 2 columns like this: users will look up the "codinternocomputacional" and then the "CODCANALCOMUNICACIONCLI". Is this the best way to do it for a faster query?<!--Cardinalidad Recipient vs. PREFERNCIACOMUNICACION 1-N --><element integrity="normal" label="Recipient" name="re...