Create another Dimension for import jobs

[ericliefke]

Hey all,

in our model we will receive following data from import jobs:

The dimensions in our model also include a concatination of DIM1, DIM4 and DIM5 like "1234_XX_123456".

Is there a way to setup the import or a data action to create this concat? the additional DIM6 would only be a concat always so is should just be a output of concatination.

Thanks in advance!

BR Eri

[William_Yu · Accepted solution]

you can directly do that during data wrangling of import job.

[ericliefke · Accepted solution]

Perfect, thanks for the fast reply. Is there a way to set this up automatically to not configure this everytime?

[William_Yu · Accepted solution]

If this is a scheduled job, the same transformation will be reused. And you can also change a datasource on an existing import job, you may also reuse the transformation if the structure is identical.