Alan
- Total activity 390
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 46
- Subscriptions 167
Comments
Votes on activity by Alan-
Hi Rick, You're correct, YEAR is a reserved word. You can find information about using reserved words as well as a link to Microsoft's documentation for the Transact-SQL specification we follow he...
-
Hi Mario, Our AVERAGE function provides the average of each row for the columns specified as arguments. For example, if you have three columns and AVERAGE them as follows: AVERAGE(Column1;Column2;C...
-
Hi Elwyn, If you wrapped the column data in a T() function, it would be simple string data in the new column. First I have to ask what's probably a silly question: You're applying the REGEX functi...
-
Hi Betty, First, create a column with RAND() in it to generate a column of random values. Since RAND() generates a number between 0 and 1, you can use this column as a comparative column to determi...
-
Hi Umasankar, This can be achieved with the CASE statement or a nested IF statement. You can see a full working example with sample data within the CASE documentation. Simply replace the <return va...
-
Official comment Hi Elwyn, I created some test data to figure this out and we needed to account for the milliseconds: ASDATE(#date_test!date; 'dd-MMM-yy hh.mm.ss.SSSSSS a')
-
Official comment Hi Mallinath, Can you please clarify what you want your result to be if the strings meet the match criteria? Is there going to be a third column providing the terms for matching? Will the first wor...
-
Official comment Hi Brendan, Sorry for the late response, it seems there was a Zendesk email notification outage the day you posted this! I tested and was able to get the desired result with syntax like in your fir...
-
Hi Wedmore, If you just want to drop these records - the easiest way to do that is in your Data Link or Import Job on the Define Fields step. Change the column to Integer, then scroll down to the H...
-
Hi Steve, You should be able to use GROUPBOTTOMN to do this. Selects the bottom N values from a group. If this function is applied on a date column, bottom N means the N least recent dates. So to g...