0

data warehouse concatenate?

Bianca Groene

March 28, 2019 13:17

None

Follow

User Guide "Jet Data Manager 2016" on page 121: Moving an concatenating a field from staging to data warehouse

I did this in Jet Data Manager Version 17...........

I'm confused... In Version 18 I can't find this function? If I try to drag and drop the field I only get a copy and no window to choose the method "Concatination".

I have a field "ArtNo" and a field "Var" and I want to create a new field in the table in the data warehouse which combines both:

ArtNo: 110002
Var: 001
new field: 110002-001

How can I do this?

Thank you!
Bianca

• Facebook
• Twitter
• LinkedIn

2 comments

• 1
  
  David Zebrowitz March 28, 2019 14:41

  Assuming both fields reside in the same staging table, the best way to do this is the following:

  1. In the Business Unit / Staging table, add a custom field with the type of "Text" and a text length which is long enough to accommodate the concatenated text.

  2. Right click on the new custom field and select "Field Transformations"

  3. In the lower right corner, ensue "Custom value" is selected and click Add

  4. Drag and drop your two fields into the query pane.  The end result should look like this:  [ArtNo] + '-' + [Var]

  Now drag that new custom field into your DW table.

   

  David Zebrowitz

   

   

   

  Edited by David Zebrowitz March 28, 2019 14:41
• 0
  
  Bianca Groene April 06, 2019 08:44

  Thank you!