- 1. ZohoCRM: Process all records of a module
- / Zoho /
- ... by "Processed" is "Selected", check after each run of the function that the number has incremented. Once all records are done, return to the Module Layout and delete the "Processed" field. [Optional conditionally] ...
- Created on 24 August 2021
- 2. Excel - Check a column for values found in another column
- / Excel /
- ... to other cells. You should end up with something like this (I have added some conditional formatting which colors the cells red or green for demonstration purposes): If you understand this ...
- Created on 14 February 2019
- 3. Add attribute xsl:nil=true on empty elements using XSLT
- / XML Stylesheet Language Transformations /
- What? An article on how to declare an XML element as NULL using the attribute "xsi:nil". I'm going to use a very short example by providing a blank date of birth value: -- What I have: // -- ...
- Created on 18 August 2014
- 4. SSIS Skip Blank Rows in Flat File Source
- / SQL Server Integration Services /
- What? This is a quick article to remind me on how to skip blank rows when using a Flat file as a data source. I would receive another Microsoft error as clear as mud: Error: The conditional operation ...
- Created on 23 April 2013
- 5. SSIS Skip Rows in Excel Source file
- / SQL Server Integration Services /
- ... Additional We add a conditional split task to the data flow which only passes through rows from the Excel sheet which are not blank/null. Browsing the net, I found this is sometimes also used for ...
- Created on 04 April 2013
- 6. SSIS Convert a string into a date
- / SQL Server Integration Services /
- ... failure. -- often when processing a datasource, the function is being applied to a NULL date timestamp. Dealing with Date NULLs: Fix: Put conditional statements to account for NULLs. -- Standard TRIM(This_Date) ...
- Created on 14 March 2013
- 7. SSRS Querying on either of 2 Parameters
- / SQL Server Reporting Services /
- ... I need to change it to a conditional query with the OR statement below: Lets take the following query as an example: SELECT table1.studentID , table2.studentUsername FROM table1, ...
- Created on 19 July 2011