Search found 145 matches

by bartonv
Thu Aug 27, 2020 9:37 am
Forum: CloverDX (formerly CloverETL) Support
Topic: How to Unpivot a Table by using CLoverDx
Replies: 1
Views: 186

Re: How to Unpivot a Table by using CLoverDx

Hello Nitish, there are at least 2 options how you can approach this challenge both of which I have demonstrated in the attached graph: 1. Using the MetaPivot component ⋅ This component is quite elegant and easy to use because it does not require any configuration. It automatically convert...
by bartonv
Thu Jun 18, 2020 3:07 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: CloverDX Runtime terminated during designer startup
Replies: 1
Views: 413

Re: CloverDX Runtime terminated during designer startup

This has been dealt with in a support ticket directly (outside of the CloverDX Forum channel).
by bartonv
Thu Jun 04, 2020 1:24 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: NLTK with Clover
Replies: 3
Views: 1041

Re: NLTK with Clover

Hi Uykusuzzzz, let me answer your questions below: ⋅ I am not familiar with NLTK and its usage but generally speaking, CloverDX does not possess machine learning capabilities. ⋅ Generally, the easiest, most convenient, and error-prone way of using Python in CloverDX data transfor...
by bartonv
Wed Jun 03, 2020 12:56 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Excel to XML Transforming Issue
Replies: 2
Views: 1073

Re: Excel to XML Transforming Issue

Hi Burakburak, first of all, I would suggest reviewing our documentation (namely the first example shown in Figure 56.27. Mapping Editor) details on how to design the mapping in different situations. To demonstrate the practice, I have attached a simple example graph that resembles your use case. Wo...
by bartonv
Wed Jun 03, 2020 12:08 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Spreadsheet Does Not Exist
Replies: 4
Views: 1760

Re: Spreadsheet Does Not Exist

Hi Staraptor78, I presume that the issue occurs repeatedly for the same files. If my assumption is correct could you provide an example of such an Excel file so that I can test it on my end? If my assumption is not correct can you confirm that at the time of the graph execution, the files: ⋅&nb...
by bartonv
Tue May 19, 2020 3:03 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Clear Persistent Lookup
Replies: 6
Views: 1620

Re: Clear Persistent Lookup

Hi Paul, just a thought on the issue with being unable to delete the .db file, could you confirm that you intend to delete the file in a later phase than the lookup table is being written into (as the screenshot provided by David indicates)? Similarly, can you confirm that the file is not "in-u...
by bartonv
Tue May 19, 2020 2:54 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: GC overhead limit exceeded
Replies: 3
Views: 1305

Re: GC overhead limit exceeded

Hi,
before jumping into conclusions, I would like to inspect the behind-the-scenes information of the Designer. Please provide me with CloverDX Designer log files called "CloverDX.log" and ".log" that are both located in the .metadata directory within your workspace.
Best regards,
by bartonv
Thu May 07, 2020 7:58 am
Forum: CloverDX (formerly CloverETL) Support
Topic: BufferOverflowException
Replies: 1
Views: 883

Re: BufferOverflowException

Hello, this error message is quite common and is typically caused by one of the following two conditions: 1. An error in the input file For instance, a record delimiter or field delimiter is missing in the input file or there is one more delimiter than it should be. This can corrupt the parsing of t...
by bartonv
Wed Apr 08, 2020 8:39 am
Forum: CloverDX (formerly CloverETL) Support
Topic: GC overhead limit exceeded
Replies: 3
Views: 1305

Re: GC overhead limit exceeded

Hi,
please refer to this post where we already discussed the "GC overhead limit exceeded" topic before:

viewtopic.php?f=4&t=7862

If you continued having issue even after increasing the maximum heap size limit, feel free to get back to us.

Kind regards,
by bartonv
Mon Mar 23, 2020 11:45 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Word Documents
Replies: 2
Views: 1207

Re: Word Documents

Hi Amaiolo, unfortunately, there is currently no built-in component that would allow for reading Word documents out-of-the-box. However, it should be feasible by leveraging our CustomJavaComponent in combination with Apache POI . This way you can program your own Word reader component and use it in ...
by bartonv
Fri Mar 20, 2020 3:08 pm
Forum: Cookbook
Topic: How to adjust length and scale of decimal datatype?
Replies: 1
Views: 1306

Re: How to adjust length and scale of decimal datatype?

Hi there, the length and scale can be changed: ⋅ by editing the metadata (CloverDX Designer > Outline pane > Metadata), ⋅ in the Metadata Wizard, click on the desired decimal-type field, ⋅ locate the 'Length' and 'Scale' properties in the grid on the right, ⋅ ...
by bartonv
Tue Mar 10, 2020 1:16 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: GC overhead limit exceeded
Replies: 1
Views: 1421

Re: GC overhead limit exceeded

Hello, the "GC overhead limit reached" exception is typically thrown because the amount of live data barely fits into the Java heap having little free space for new allocations. A more in-depth explanation can be found in this article in the Oracle Java Documentation . To make the long sto...
by bartonv
Fri Feb 21, 2020 2:49 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Dynamically create MS Access tables in a graph
Replies: 1
Views: 1453

Re: Dynamically create MS Access tables in a graph

Hi Dahb, I am not quite sure what you meant by your question. If you don't mind I would like to clarify a couple of details: ⋅ By dynamically creating tables, did you mean using the dynamic metadata functionality in CloverDX? Please note that the concept of dynamic metadata was greatly imp...
by bartonv
Fri Feb 21, 2020 2:28 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: How to use the median function
Replies: 1
Views: 1389

Re: How to use the median function

Hi there,
to be able to use the median function, it is necessary to normalize the data first before they flow into Aggregate. I have attached a simple example of how this can be done using the Normalizer component.
Best regards,

cron