# CloverDX Platform

**URL:** https://forum.cloverdx.com/c/cloverdx/5.md?page=2

[Latest](https://forum.cloverdx.com/latest.md) · [Categories](https://forum.cloverdx.com/categories.md)

**Page:** 3

---

## [How to utilize dictionary values in Salesforce reader soql](https://forum.cloverdx.com/t/how-to-utilize-dictionary-values-in-salesforce-reader-soql/2143)

<div class="topic-metadata">

**Author:** [@Jeff\_Mueller](https://forum.cloverdx.com/u/Jeff_Mueller)\
**Replies:** 1\
**Last updated:** [June 13, 2023, 12:00am UTC](https://forum.cloverdx.com/t/how-to-utilize-dictionary-values-in-salesforce-reader-soql/2143 "2023-06-13T00:00:00Z")

</div>

How to I make this work to pull parent records. I have stored the list of Id’s in the dictionary. Id does not like this: dict:parentIdCSV:discrete Select FIELDS(ALL) From Account WHERE Id in dict:parentIdCSV:discrete

---

## [CloverDX Server Sandbox Output file to use](https://forum.cloverdx.com/t/cloverdx-server-sandbox-output-file-to-use/2142)

<div class="topic-metadata">

**Author:** [@CloverDxNewBie](https://forum.cloverdx.com/u/CloverDxNewBie)\
**Replies:** 2\
**Last updated:** [March 31, 2023, 12:00am UTC](https://forum.cloverdx.com/t/cloverdx-server-sandbox-output-file-to-use/2142 "2023-03-31T00:00:00Z")

</div>

Dear Support, I have a scheduled flow running on CloverDX server - I am creating a new flow for which I need to access one of the output produced from one of the flow on the server. https://CloverServerlUrl Sandbox: A…

---

## [CloverDX reading 7Zip file contents](https://forum.cloverdx.com/t/cloverdx-reading-7zip-file-contents/2141)

<div class="topic-metadata">

**Author:** [@CloverDxNewBie](https://forum.cloverdx.com/u/CloverDxNewBie)\
**Replies:** 2\
**Last updated:** [March 22, 2023, 12:00am UTC](https://forum.cloverdx.com/t/cloverdx-reading-7zip-file-contents/2141 "2023-03-22T00:00:00Z")

</div>

Dear CloverDX Admins/Users/Support I have quite few 7z (7Zip) files and these are over 400MBs, I wanted to only list the file names and details within the zip (7z) of the file and list those in a table, is this possible…

---

## [Date incorrect parsing from Excel](https://forum.cloverdx.com/t/date-incorrect-parsing-from-excel/670)

<div class="topic-metadata">

**Author:** [@mkutti](https://forum.cloverdx.com/u/mkutti)\
**Replies:** 8\
**Last updated:** [March 7, 2023, 12:00am UTC](https://forum.cloverdx.com/t/date-incorrect-parsing-from-excel/670 "2023-03-07T00:00:00Z")

</div>

When I read a Excel file using XLS component, Date value Aug 07 2009 changes to 0007, August 07, 2009. Metadata is defined as String. Is this a bug ? Any workaround ? Thank you.

---

## [Access Multiple Records and Update Values Dynamically?](https://forum.cloverdx.com/t/access-multiple-records-and-update-values-dynamically/2134)

<div class="topic-metadata">

**Author:** [@Justin\_Tran](https://forum.cloverdx.com/u/Justin_Tran)\
**Replies:** 5\
**Last updated:** [March 2, 2023, 12:00am UTC](https://forum.cloverdx.com/t/access-multiple-records-and-update-values-dynamically/2134 "2023-03-02T00:00:00Z")

</div>

I’m trying to do a transform where 2 integer values are subtracted from 2 different records that each have a unique ID. Each record contains a value, a unique ID referencing itself, and an ID referencing another record. …

---

## [How to show top number of unique values in ProfilerProbe Frequency Histogram](https://forum.cloverdx.com/t/how-to-show-top-number-of-unique-values-in-profilerprobe-frequency-histogram/2140)

<div class="topic-metadata">

**Author:** [@slau](https://forum.cloverdx.com/u/slau)\
**Replies:** 1\
**Last updated:** [February 17, 2023, 12:00am UTC](https://forum.cloverdx.com/t/how-to-show-top-number-of-unique-values-in-profilerprobe-frequency-histogram/2140 "2023-02-17T00:00:00Z")

</div>

I am using the Frequency Chart metric in ProfilerProbe to get the frequency of values in a table. Curently there is a property that allows you to limit the maximum number of unique values, however if this threshold is e…

---

## [How to merge two lists or dedup a list string in a reformat](https://forum.cloverdx.com/t/how-to-merge-two-lists-or-dedup-a-list-string-in-a-reformat/2135)

<div class="topic-metadata">

**Author:** [@michaelj](https://forum.cloverdx.com/u/michaelj)\
**Replies:** 2\
**Last updated:** [December 28, 2022, 12:00am UTC](https://forum.cloverdx.com/t/how-to-merge-two-lists-or-dedup-a-list-string-in-a-reformat/2135 "2022-12-28T00:00:00Z")

</div>

I have two string fields that each has a list of states separated with semi-colons that I would like to combine into one field but without duplicating any of the states. For instance, the data coming into the reformat wo…

---

## [Read flat file with most recent create date](https://forum.cloverdx.com/t/read-flat-file-with-most-recent-create-date/2136)

<div class="topic-metadata">

**Author:** [@Tim\_Dombrowski](https://forum.cloverdx.com/u/Tim_Dombrowski)\
**Replies:** 3\
**Last updated:** [December 28, 2022, 12:00am UTC](https://forum.cloverdx.com/t/read-flat-file-with-most-recent-create-date/2136 "2022-12-28T00:00:00Z")

</div>

Is there a component option that will allow the FlatFileReader to locate a file in a directory with the most recent create (or update) date? For example the directory I am reading from contains 4 files and new files will…

---

## [JSON Writer](https://forum.cloverdx.com/t/json-writer/2137)

<div class="topic-metadata">

**Author:** [@Aadharsh\_Nair](https://forum.cloverdx.com/u/Aadharsh_Nair)\
**Replies:** 1\
**Last updated:** [December 27, 2022, 12:00am UTC](https://forum.cloverdx.com/t/json-writer/2137 "2022-12-27T00:00:00Z")

</div>

Hello everyone! Using the JSON Writer component - I have added a collection called “SourceCheck”. Is there a way to make this collection tag completely disappear when the “attType” tag (in the parent element) = “qwerty…

---

## [How to store value when subsequent file are process from same graph](https://forum.cloverdx.com/t/how-to-store-value-when-subsequent-file-are-process-from-same-graph/2139)

<div class="topic-metadata">

**Author:** [@Ketan](https://forum.cloverdx.com/u/Ketan)\
**Replies:** 1\
**Last updated:** [December 27, 2022, 12:00am UTC](https://forum.cloverdx.com/t/how-to-store-value-when-subsequent-file-are-process-from-same-graph/2139 "2022-12-27T00:00:00Z")

</div>

Have got two file that need to be process subsequently. With in that each file have got value that required to be added. Now the issue is when first file is process can save value into dictionary but when second file is …

---

## [Using a SQL triggar run a clover graph](https://forum.cloverdx.com/t/using-a-sql-triggar-run-a-clover-graph/2138)

<div class="topic-metadata">

**Author:** [@William\_Wilson](https://forum.cloverdx.com/u/William_Wilson)\
**Replies:** 1\
**Last updated:** [December 23, 2022, 12:00am UTC](https://forum.cloverdx.com/t/using-a-sql-triggar-run-a-clover-graph/2138 "2022-12-23T00:00:00Z")

</div>

I want a clover graph to run when a record is inserted into a sql table. Is there a way a sql triggar could kick off a clover graph?

---

## [Dynamic Table Name](https://forum.cloverdx.com/t/dynamic-table-name/2133)

<div class="topic-metadata">

**Author:** [@Yijin\_Ren](https://forum.cloverdx.com/u/Yijin_Ren)\
**Replies:** 1\
**Last updated:** [October 26, 2022, 12:00am UTC](https://forum.cloverdx.com/t/dynamic-table-name/2133 "2022-10-26T00:00:00Z")

</div>

Is it possible to design a graph to select data from multiple tables in Snowflake Database where their table names are values from a column of another table? I have a Master Table in Snowflake DB consists of all the tab…

---

## [Private key for connecting to sftp (schedules)](https://forum.cloverdx.com/t/private-key-for-connecting-to-sftp-schedules/2132)

<div class="topic-metadata">

**Author:** [@Igne\_Krapikaite](https://forum.cloverdx.com/u/Igne_Krapikaite)\
**Replies:** 3\
**Last updated:** [September 6, 2022, 12:00am UTC](https://forum.cloverdx.com/t/private-key-for-connecting-to-sftp-schedules/2132 "2022-09-06T00:00:00Z")

</div>

Hi support, I can see how you can utilise private key and ssh config file for connecting to sftp through event listeners. Alternatively, for designer you offer to place the key in a ssh folder in the project. Is there …

---

## [JSONExtract fails when run command line](https://forum.cloverdx.com/t/jsonextract-fails-when-run-command-line/2131)

<div class="topic-metadata">

**Author:** [@Jose\_Arregoces](https://forum.cloverdx.com/u/Jose_Arregoces)\
**Replies:** 1\
**Last updated:** [August 29, 2022, 12:00am UTC](https://forum.cloverdx.com/t/jsonextract-fails-when-run-command-line/2131 "2022-08-29T00:00:00Z")

</div>

Hi, Running a graph in Designer Community 4.8 with a JSONExtract component works. Running the same graph via command line causes the following failure: ERROR \[main\] - Error in reading graph from XML ! Unknown compone…

---

## [MongoDB connection error "Prematurely reached end of stream"](https://forum.cloverdx.com/t/mongodb-connection-error-prematurely-reached-end-of-stream/2128)

<div class="topic-metadata">

**Author:** [@Sylvester\_Noronha](https://forum.cloverdx.com/u/Sylvester_Noronha)\
**Replies:** 7\
**Last updated:** [August 23, 2022, 12:00am UTC](https://forum.cloverdx.com/t/mongodb-connection-error-prematurely-reached-end-of-stream/2128 "2022-08-23T00:00:00Z")

</div>

cannot connect to mongoDB database. Please take a look at the attached images for details

---

## [Connection Refused when trying to validate secrete manager with Azure Key Vault](https://forum.cloverdx.com/t/connection-refused-when-trying-to-validate-secrete-manager-with-azure-key-vault/2130)

<div class="topic-metadata">

**Author:** [@Ronnie\_Ren](https://forum.cloverdx.com/u/Ronnie_Ren)\
**Replies:** 1\
**Last updated:** [August 22, 2022, 12:00am UTC](https://forum.cloverdx.com/t/connection-refused-when-trying-to-validate-secrete-manager-with-azure-key-vault/2130 "2022-08-22T00:00:00Z")

</div>

Secret Manager validation failed Connection failed Connection refused: no further information: xxxxx.vault.azure.net/xxx.xxx.xx.xxx:443 Suppressed: #block terminated with an error org.jetel.exception.JetelRuntimeExce…

---

## [CustomJavaTransformer Usage Example](https://forum.cloverdx.com/t/customjavatransformer-usage-example/2129)

<div class="topic-metadata">

**Author:** [@Alan\_Ortiz](https://forum.cloverdx.com/u/Alan_Ortiz)\
**Replies:** 1\
**Last updated:** [August 16, 2022, 12:00am UTC](https://forum.cloverdx.com/t/customjavatransformer-usage-example/2129 "2022-08-16T00:00:00Z")

</div>

Hello, could someone provide me with an example of how the JavaCustomTransformer component is used, I have already read the documentation but it is not very understandable. Thank you

---

## [How to get first value from list of string](https://forum.cloverdx.com/t/how-to-get-first-value-from-list-of-string/2127)

<div class="topic-metadata">

**Author:** [@Sylvester\_Noronha](https://forum.cloverdx.com/u/Sylvester_Noronha)\
**Replies:** 2\
**Last updated:** [August 1, 2022, 12:00am UTC](https://forum.cloverdx.com/t/how-to-get-first-value-from-list-of-string/2127 "2022-08-01T00:00:00Z")

</div>

I am extracting data from an api and one field called FileUrl as multiple URLs as string with comma as the delimiter. I mapped it to a field with type list\[string\] in the metadata and want to extract the first value(firs…

---

## [Worker Will Not Start](https://forum.cloverdx.com/t/worker-will-not-start/2126)

<div class="topic-metadata">

**Author:** [@Nick\_Alder](https://forum.cloverdx.com/u/Nick_Alder)\
**Replies:** 1\
**Last updated:** [May 10, 2022, 12:00am UTC](https://forum.cloverdx.com/t/worker-will-not-start/2126 "2022-05-10T00:00:00Z")

</div>

After updating to CloverDX Server v14.1 and upgrading to the recommended Eclipse Temurin JDK with Hotspot 11.0.15, Worker will not start. We have tried reinstalling all components of our CloverDX server setup, as well as…

---

## [DBExecute on MariaDB (Mapping of Clover fields](https://forum.cloverdx.com/t/dbexecute-on-mariadb-mapping-of-clover-fields/2125)

<div class="topic-metadata">

**Author:** [@otto\_brunner](https://forum.cloverdx.com/u/otto_brunner)\
**Replies:** 1\
**Last updated:** [March 3, 2022, 12:00am UTC](https://forum.cloverdx.com/t/dbexecute-on-mariadb-mapping-of-clover-fields/2125 "2022-03-03T00:00:00Z")

</div>

Hi When doing an SQL-Update with DBExecute in a MariaDB update ADRESSEN set ADRESSEN.VStatus = ‘CHG’ where ADRESSEN.MCC\_NUMERO = $MCC\_NUMERO an error “Unknown column ‘$MCC\_NUMERO’ in ‘where clause’” is triggered. I …

---

## [Detect zero byte file](https://forum.cloverdx.com/t/detect-zero-byte-file/2124)

<div class="topic-metadata">

**Author:** [@Mike\_Podgorski](https://forum.cloverdx.com/u/Mike_Podgorski)\
**Replies:** 1\
**Last updated:** [February 11, 2022, 12:00am UTC](https://forum.cloverdx.com/t/detect-zero-byte-file/2124 "2022-02-11T00:00:00Z")

</div>

I have a job that reads a pipe (|) delimited file, using a UniversalDataReader, and writes the contents to a database table. We a have an issue where the supplier of the files occasionally sends a file with no data in it…

---

## [CloverDX Runtime terminated during designer startup](https://forum.cloverdx.com/t/cloverdx-runtime-terminated-during-designer-startup/2089)

<div class="topic-metadata">

**Author:** [@elden.jahnke](https://forum.cloverdx.com/u/elden.jahnke)\
**Replies:** 4\
**Last updated:** [January 11, 2022, 12:00am UTC](https://forum.cloverdx.com/t/cloverdx-runtime-terminated-during-designer-startup/2089 "2022-01-11T00:00:00Z")

</div>

Hello We have been working on designer authoring some graphs without issues for the past couple weeks Suddenly today, I see an error about the CloverDX designer embedded runtime being terminated which prevents us from …

---

## [Syntax to use dictionary value as component config](https://forum.cloverdx.com/t/syntax-to-use-dictionary-value-as-component-config/2123)

<div class="topic-metadata">

**Author:** [@morganizer](https://forum.cloverdx.com/u/morganizer)\
**Replies:** 1\
**Last updated:** [November 8, 2021, 12:00am UTC](https://forum.cloverdx.com/t/syntax-to-use-dictionary-value-as-component-config/2123 "2021-11-08T00:00:00Z")

</div>

I need to be able pass a dictionary values to attribute fields of a graph components, in this case to the Username and Password of an HTTPConnector. Where in the console log I might see something like: DictEntry:user:s…

---

## [Import 3rd party jars into CloverDX](https://forum.cloverdx.com/t/import-3rd-party-jars-into-cloverdx/2072)

<div class="topic-metadata">

**Author:** [@ryang420](https://forum.cloverdx.com/u/ryang420)\
**Replies:** 4\
**Last updated:** [October 19, 2021, 12:00am UTC](https://forum.cloverdx.com/t/import-3rd-party-jars-into-cloverdx/2072 "2021-10-19T00:00:00Z")

</div>

Hi all, As we know, when you’re using java related components, like CustomJavaReader, you probably need to import some 3rd party jars. Instead of adding the jar file on the classpath explicitly (in CloverDX Designer rig…

---

## [BSON Extract](https://forum.cloverdx.com/t/bson-extract/2122)

<div class="topic-metadata">

**Author:** [@lookatmyname](https://forum.cloverdx.com/u/lookatmyname)\
**Replies:** 1\
**Last updated:** [August 6, 2021, 12:00am UTC](https://forum.cloverdx.com/t/bson-extract/2122 "2021-08-06T00:00:00Z")

</div>

A client recently sent me a large BSON file, exported from MongoDB. What is the best solution to extract this data? There are some updates that mention BSON support, but I can’t seem to find any resources on this. The on…

---

## [How to do dynamic data profiling](https://forum.cloverdx.com/t/how-to-do-dynamic-data-profiling/2121)

<div class="topic-metadata">

**Author:** [@bea95](https://forum.cloverdx.com/u/bea95)\
**Replies:** 1\
**Last updated:** [July 27, 2021, 12:00am UTC](https://forum.cloverdx.com/t/how-to-do-dynamic-data-profiling/2121 "2021-07-27T00:00:00Z")

</div>

Hi I am trying to make a more general purpose data profiling graph that get the Sum, Count, Distinct Count,Null,Not null, Min Value Max Value,Min Lengh,Max Lengh for each field that is present in the metadata. We have m…

---

## [Query on RunGraph component](https://forum.cloverdx.com/t/query-on-rungraph-component/2120)

<div class="topic-metadata">

**Author:** [@balaji.venkatachalam](https://forum.cloverdx.com/u/balaji.venkatachalam)\
**Replies:** 2\
**Last updated:** [July 12, 2021, 12:00am UTC](https://forum.cloverdx.com/t/query-on-rungraph-component/2120 "2021-07-12T00:00:00Z")

</div>

I have a query on RunGraph component. Say there is a main graph GraphA with the RunGraph component whose Graph URL is set as another graph GraphB. GraphA triggers GraphB with the RunGraph components & capture the outpu…

---

## [Linux soft link stopped working for ListFiles on CloverDX 5.11.0](https://forum.cloverdx.com/t/linux-soft-link-stopped-working-for-listfiles-on-cloverdx-5-11-0/2119)

<div class="topic-metadata">

**Author:** [@jzhu](https://forum.cloverdx.com/u/jzhu)\
**Replies:** 1\
**Last updated:** [July 2, 2021, 12:00am UTC](https://forum.cloverdx.com/t/linux-soft-link-stopped-working-for-listfiles-on-cloverdx-5-11-0/2119 "2021-07-02T00:00:00Z")

</div>

Linux soft link works for ListFiles on CloverETL 4.3.0, but does not work on CloverDX 5.11.0 (not work on 5.10.1 either). The use case is to change data-in etc. in project sandbox to point to RAM disk with soft link. Er…

---

## [Execute a block of components in a loop](https://forum.cloverdx.com/t/execute-a-block-of-components-in-a-loop/2118)

<div class="topic-metadata">

**Author:** [@balaji.venkatachalam](https://forum.cloverdx.com/u/balaji.venkatachalam)\
**Replies:** 4\
**Last updated:** [July 1, 2021, 12:00am UTC](https://forum.cloverdx.com/t/execute-a-block-of-components-in-a-loop/2118 "2021-07-01T00:00:00Z")

</div>

Hi, I am working on generating a report where in: 1. Retrieve a set of data from database A. 2. Retrieve a list of IDs from another database B. 3. For each item in the list, retrieve the details from database B. 4. …

---

## [The Java way of doing the Execute Shell Command and also the Send Email](https://forum.cloverdx.com/t/the-java-way-of-doing-the-execute-shell-command-and-also-the-send-email/2117)

<div class="topic-metadata">

**Author:** [@nismon8er](https://forum.cloverdx.com/u/nismon8er)\
**Replies:** 1\
**Last updated:** [June 17, 2021, 12:00am UTC](https://forum.cloverdx.com/t/the-java-way-of-doing-the-execute-shell-command-and-also-the-send-email/2117 "2021-06-17T00:00:00Z")

</div>

Hello, Unfortunately I do not have access to Clover Server (reasons above my pay grade) so I was tasked with mimicking those actions in a CustomJavaComponent (or whatever this would be more suitable for). Pretty much o…

[Previous page](https://forum.cloverdx.com/c/cloverdx/5.md?page=1)

[Next page](https://forum.cloverdx.com/c/cloverdx/5.md?page=3)
