Niels Thomsen
Activity overview
Latest activity by Niels Thomsen-
Niels Thomsen commented, Hi Bo Great that you we're able to fix it. The custom account is needed as it is mentioned in the release notes: If running Data Discovery with a service account that has specific access to files ...
-
Niels Thomsen commented, Hi Willer Cannot add float and string typically means that a certain measure has been designed in a way that tries to add a number and a string (text) - which will throw an error inside TARGIT br/N...
-
Niels Thomsen commented, Hi Willer I'm sorry but the communication in this forum needs to be in English for all to benefit from the questions and answers :-) However - I think I translated your question into the error mess...
-
Niels Thomsen created an article, Parent-child - how to transform and get ready for TARGIT Data Model Editor
This example shows how to read from a database table where parent-child is implemented in a traditional way, and transform this into a dimension table that can be utilized directly in the TARGIT Da...
-
Niels Thomsen created an article, CSV and Excel import loop
This is an example of reading through a list of csv and excel files and appending them to an inmemory table. The project can be used as inspiration and starting point if you need to read through a ...
-
Niels Thomsen created an article, Using While-do loop from toolbox to import tables in parallel
This is an example of using the while-do task from the toolbox in ETL studio. The project loops through company table and for each entry in the table, the corresponding tables are loaded. (This is ...
-
Niels Thomsen created an article, Using the Enum task from the toolbox in ETL Studio
Example using the Enumeration Task to create meaningful text from numeric codes. The Enum Task is in the toolbox of ETL Studio and allows you to design and create lookup tables that makes codes (...
-
Niels Thomsen created an article, Retrieving information from REST Api with loop from input list
This script is a simple example of communication with a REST API using ETL studio. An input list is read - an for each entry the REST API is called and information retrieved - so the script contain...
-
Niels Thomsen commented, Hi Jean Pierre I guess you are trying to add a sort of wildcard on the first level - marked in bold below sum(@"";"[True]"(l(1,0)), 0, m1) That isn't supported in the syntax - which makes your prob...
-
Niels Thomsen commented, Hi Lara If you have 2 attributes on the same axis, they form a custom hierarchy. sum(d2(l(1,0)),0,m1) in my example means something like: The second column (d2) - level 1 on the first attribute (Ye...