I'd like to know how to use CDI to concatenate source data. For example, in SQL, I would use something like this:
SELECT [SomeStuff], 'VALUE TO CONCATENATE: ' + [FieldToConcatenate] as ConcatenatedField
FROM [SomeTable]
What tools would I use in CDI to accomplish this?
There are two ways to do this in Centerprise.
1)Use a function map and select the Concatenate function. This will present you with 2 inputs that you'll map to from your source. You can map one value from the source and the other input could be a constant such as "value to concatenate". The output will be the concatenated value.
2)Use an expression map. The expression can consist of field values to concatenate and constant values in the expression and the + operator. For example, FieldToConcatenate + "VALUE TO CONCATENATE". The output will be the concatenated expression.
Thank you. The Expression map seems most useful. However, one of my source values that I would like to concatenate is a date. Do you know how I can "cast" or convert the date value into a string?
There is a ToString function in the Conversion category, I believe. You can supply your date value into that function to get your desired string. There is also an optional second parameter that will let you control the format of your date as a string. e.g. "yyyyMMdd:hhmmss", where y = year, M = month, d = day, h = hour, m = minute, and s = second.
I am having a little trouble using the Expression builder. I open my Expression's properties and go to the second page. In Categroies I select "Conversion". In the list I see "Converts a date value into string using default culture" and double-click it. However, in the expression box I DO NOT see a formula like ToString(value) but rather "Converts a date value into string using default culture.(value)"
How do I get the actual expression and not just a desription of the expression?
Ah, it looks like you downloaded a build that had this mistake in it. Download the latest version from the website to correct this problem.
I downloaded the new build. I uninstalled what was on my PC and tried to install from the new build. However, it failed with an error 1904. Module C:\Program Files (x86)\Common Files\Intuit\QuickBooks\QBXMLRP2.dll failed to register. HRESULT -2147220473
See attached image.
That issue has been fixed as well. I'll update your open support ticket once the build is uploaded.
