search

Seddryck / NBi

NBi is a testing framework (add-on to NUnit) for Business Intelligence and Data Access. The main goal of this framework is to let users create tests with a declarative approach based on an Xml syntax. By the means of NBi, you don't need to develop C# or Java code to specify your tests! Either, you don't need Visual Studio or Eclipse to compile your test suite. Just create an Xml file and let the framework interpret it and play your tests. The framework is designed as an add-on of NUnit but with the possibility to port it easily to other testing frameworks.
http://www.nbi.io
Apache License 2.0
106 stars 37 forks source link

Genbil - substring replace? #714

Closed fefeslon closed 10 months ago

fefeslon commented 1 year ago

Hi All,

Is it currently possible to make substring replace in the Genbil?

E.G. Imagine you have objects like dim_prod, fact_sales etc.. Each environemnt (TST, PRD.) has its own suffix on objects like: dim_prod_tst, dim_prod_prd I would like to get list of "general" object name like dim_prod, fat_sales and then apply this to template.

https://www.nbi.io/automation/column-replace/

Is it possible to replace just suffix/prefix/substring somehow?

If not, could it be added please or is it too much effort?

Cheers,

Michal.

Seddryck commented 1 year ago

Using substitute you should be able to substitute the dim_ of dim_product by dim_prod which should end into dim_prod_product.

fefeslon commented 1 year ago

Ah cool, thanks Cedric.

I haven't noticed it in the documentation.