# Latest **URL:** https://forum.cloverdx.com/latest.md?page=1 [Latest](https://forum.cloverdx.com/latest.md) · [Categories](https://forum.cloverdx.com/categories.md) **Page:** 2 --- ## [Empty Source DB to target, but inspect data is showing 1 null record](https://forum.cloverdx.com/t/empty-source-db-to-target-but-inspect-data-is-showing-1-null-record/3178)
**Author:** [@MAKEFLO](https://forum.cloverdx.com/u/MAKEFLO)\ **Replies:** 1\ **Last updated:** [November 20, 2024, 1:20pm UTC](https://forum.cloverdx.com/t/empty-source-db-to-target-but-inspect-data-is-showing-1-null-record/3178 "2024-11-20T13:20:41Z")
I have a straightforward transformation. Customer table for example is empty in the backend (MS SQL Server) I just used select all in Customer table on DBExecute to DatabaseWriter, but in edge it showing 1 row of NULL va… --- ## [DatabaseWriter Insert INTO having error](https://forum.cloverdx.com/t/databasewriter-insert-into-having-error/3174)
**Author:** [@MAKEFLO](https://forum.cloverdx.com/u/MAKEFLO)\ **Replies:** 1\ **Last updated:** [November 13, 2024, 9:25pm UTC](https://forum.cloverdx.com/t/databasewriter-insert-into-having-error/3174 "2024-11-13T21:25:48Z")
New to CloverDX. I am having an error in DatabaseWriter transformation when doing insert into I have DBExecute with query selecting from transactions table, using transactions metadata for edge. in DatabaseWrite I have … --- ## [Can't get start date and end date value](https://forum.cloverdx.com/t/cant-get-start-date-and-end-date-value/3172)
**Author:** [@MAKEFLO](https://forum.cloverdx.com/u/MAKEFLO)\ **Replies:** 2\ **Last updated:** [November 13, 2024, 12:09am UTC](https://forum.cloverdx.com/t/cant-get-start-date-and-end-date-value/3172 "2024-11-13T00:09:51Z")
New in CloverDX. I created a Database reader connected to trash just to test if i can use variable date variables, my query below select ‘${start\_date}’ as start\_date, ‘${end\_date}’ as end\_date I’m using metadata name … --- ## [Graphs logs retention period](https://forum.cloverdx.com/t/graphs-logs-retention-period/2172)
**Author:** [@Lubos\_Imriska](https://forum.cloverdx.com/u/Lubos_Imriska)\ **Replies:** 2\ **Last updated:** [October 22, 2024, 2:07pm UTC](https://forum.cloverdx.com/t/graphs-logs-retention-period/2172 "2024-10-22T14:07:15Z")
its possible to change/edit the retention period for the graph logs in \[your\_tomcat\_directory\]/temp/cloverlogs/graph ? --- ## [Locale - European or UK number/date formats handling](https://forum.cloverdx.com/t/locale-european-or-uk-number-date-formats-handling/2173)
**Author:** [@CloverDxNewBie](https://forum.cloverdx.com/u/CloverDxNewBie)\ **Replies:** 1\ **Last updated:** [October 31, 2024, 11:05am UTC](https://forum.cloverdx.com/t/locale-european-or-uk-number-date-formats-handling/2173 "2024-10-31T11:05:43Z")
Dear Support, I wanted to use the conversion function to produce output in UK number formats, My input file contains European and UK format number system. With the help of CloverDX support (Thank you) I have managed to… --- ## [Transposing rows into columns with column headers & column values](https://forum.cloverdx.com/t/transposing-rows-into-columns-with-column-headers-column-values/2171)
**Author:** [@CloverDxNewBie](https://forum.cloverdx.com/u/CloverDxNewBie)\ **Replies:** 1\ **Last updated:** [July 29, 2024, 12:00am UTC](https://forum.cloverdx.com/t/transposing-rows-into-columns-with-column-headers-column-values/2171 "2024-07-29T00:00:00Z")
Dear Support, We have a data as below: and we wanted to see the output as below: I have tried using MetaPivot, it did transpose the rows into columns but I am unable to group it by “Code”, I wanted to group ever… --- ## [Designer via CLI](https://forum.cloverdx.com/t/designer-via-cli/2170)
**Author:** [@sharsant](https://forum.cloverdx.com/u/sharsant)\ **Replies:** 1\ **Last updated:** [July 23, 2024, 12:00am UTC](https://forum.cloverdx.com/t/designer-via-cli/2170 "2024-07-23T00:00:00Z")
Hi all, I am configuring a developer environment and one of the requirements from our data team is to be able to locally run the CloverDX Designer via the command line whilst they develop ETL operations. (i.e., Not use … --- ## [Help using UniversalDataReader inside Loop](https://forum.cloverdx.com/t/help-using-universaldatareader-inside-loop/2169)
**Author:** [@Christopher\_Amaru](https://forum.cloverdx.com/u/Christopher_Amaru)\ **Replies:** 1\ **Last updated:** [July 16, 2024, 12:00am UTC](https://forum.cloverdx.com/t/help-using-universaldatareader-inside-loop/2169 "2024-07-16T00:00:00Z")
I have a graph that uses a ListFiles component to get all the files in a directory and read the single record in each file, doing something based on the contents of this record. I can get the record from the first file, … --- ## [Something like an external dictionary?](https://forum.cloverdx.com/t/something-like-an-external-dictionary/2168)
**Author:** [@Kasper\_Wolsink](https://forum.cloverdx.com/u/Kasper_Wolsink)\ **Replies:** 1\ **Last updated:** [July 4, 2024, 12:00am UTC](https://forum.cloverdx.com/t/something-like-an-external-dictionary/2168 "2024-07-04T00:00:00Z")
In my job flow, I have multiple nested graphs. In one of the nested graphs I perform a rest call that generates an unique identifier. Ideally, I would want to store this unique id as a global variable of the current run … --- ## [Upload binary file with a data service](https://forum.cloverdx.com/t/upload-binary-file-with-a-data-service/2164)
**Author:** [@Brandon\_Russell](https://forum.cloverdx.com/u/Brandon_Russell)\ **Replies:** 2\ **Last updated:** [June 27, 2024, 12:00am UTC](https://forum.cloverdx.com/t/upload-binary-file-with-a-data-service/2164 "2024-06-27T00:00:00Z")
I would like to use a data service to allow users to upload a zip file that is then processed by a graph. It looks like you can create form parameters that are binary. And running the data service, it allows you to pick … --- ## [Identifying CloverDX URL and installed Port number](https://forum.cloverdx.com/t/identifying-cloverdx-url-and-installed-port-number/2167)
**Author:** [@Ganesh\_Kumar](https://forum.cloverdx.com/u/Ganesh_Kumar)\ **Replies:** 1\ **Last updated:** [June 26, 2024, 12:00am UTC](https://forum.cloverdx.com/t/identifying-cloverdx-url-and-installed-port-number/2167 "2024-06-26T00:00:00Z")
Hi Team, I have installed CloverDX Designer and I need to get the installed URL and port number details on which it is installed, since I need the URL to register in application registration of Azure portal process for … --- ## [Creating and updating file like database tables](https://forum.cloverdx.com/t/creating-and-updating-file-like-database-tables/2166)
**Author:** [@CloverDxNewBie](https://forum.cloverdx.com/u/CloverDxNewBie)\ **Replies:** 1\ **Last updated:** [June 12, 2024, 12:00am UTC](https://forum.cloverdx.com/t/creating-and-updating-file-like-database-tables/2166 "2024-06-12T00:00:00Z")
Dear support, I have an incoming file (40 columns) where I read it using file reader, I will store the file with with probably updated values and new rows in an existing file what is the best way to achieve this. For e… --- ## [Email query - Processed records](https://forum.cloverdx.com/t/email-query-processed-records/2165)
**Author:** [@CloverDxNewBie](https://forum.cloverdx.com/u/CloverDxNewBie)\ **Replies:** 1\ **Last updated:** [June 10, 2024, 12:00am UTC](https://forum.cloverdx.com/t/email-query-processed-records/2165 "2024-06-10T00:00:00Z")
Dear Support, I have to write an email after processing using cloverDX graph. I have source file which will be read via File Reader, I will do some manipulation and will store a file to a location. I have to send an e… --- ## [HttpConnector not reading from column](https://forum.cloverdx.com/t/httpconnector-not-reading-from-column/2162)
**Author:** [@Mahmood\_Babalola](https://forum.cloverdx.com/u/Mahmood_Babalola)\ **Replies:** 1\ **Last updated:** [June 3, 2024, 12:00am UTC](https://forum.cloverdx.com/t/httpconnector-not-reading-from-column/2162 "2024-06-03T00:00:00Z")
I am trying to use the HTTPconnector to run an API to extract a column and put it in a certain column in the database. I am able to do it successfully when I put the body of the call in "requestContent’ for one call $ou… --- ## [CloverDX Spreadsheet writer error - Excel workbook](https://forum.cloverdx.com/t/cloverdx-spreadsheet-writer-error-excel-workbook/2163)
**Author:** [@CloverDxNewBie](https://forum.cloverdx.com/u/CloverDxNewBie)\ **Replies:** 1\ **Last updated:** [May 30, 2024, 12:00am UTC](https://forum.cloverdx.com/t/cloverdx-spreadsheet-writer-error-excel-workbook/2163 "2024-05-30T00:00:00Z")
Dear Forum Members I am getting an error writing to excel files using CloverDX server, it works fine using CloverDX client application but when I deploy the graph on to the server (production server), it failed on Sprea… --- ## [Rerun Event listener](https://forum.cloverdx.com/t/rerun-event-listener/2161)
**Author:** [@Brandon\_Russell](https://forum.cloverdx.com/u/Brandon_Russell)\ **Replies:** 1\ **Last updated:** [May 24, 2024, 12:00am UTC](https://forum.cloverdx.com/t/rerun-event-listener/2161 "2024-05-24T00:00:00Z")
I have some event file listeners that trigger on new files added to a folder. If the graph runs into an issue, files won’t be processed. What is the best way to go back and process those missed files once the graph has b… --- ## [CloverDX ETL process - Source filename to the output file name](https://forum.cloverdx.com/t/cloverdx-etl-process-source-filename-to-the-output-file-name/2160)
**Author:** [@CloverDxNewBie](https://forum.cloverdx.com/u/CloverDxNewBie)\ **Replies:** 2\ **Last updated:** [May 17, 2024, 12:00am UTC](https://forum.cloverdx.com/t/cloverdx-etl-process-source-filename-to-the-output-file-name/2160 "2024-05-17T00:00:00Z")
Dear Support, I need help with the below: 1. Reading a filename. 2.Data manipulation. 3. Writing the file with the source filename with timestamp. For example, original filename “XYZ\_ABC\_2456.xlsx” We read this fil… --- ## [Conditional sub-graph execution based on the incoming multiple metadata records from database tables](https://forum.cloverdx.com/t/conditional-sub-graph-execution-based-on-the-incoming-multiple-metadata-records-from-database-tables/2159)
**Author:** [@neelimaj](https://forum.cloverdx.com/u/neelimaj)\ **Replies:** 1\ **Last updated:** [May 9, 2024, 12:00am UTC](https://forum.cloverdx.com/t/conditional-sub-graph-execution-based-on-the-incoming-multiple-metadata-records-from-database-tables/2159 "2024-05-09T00:00:00Z")
Hi, I have a requirement where I pull records from 3 database tables and for each record in table 1, I need to run sub-graph1(needs records from all the three tables as incoming data paths to execute) to execute required… --- ## [Upload PDF document to external system through an API](https://forum.cloverdx.com/t/upload-pdf-document-to-external-system-through-an-api/2158)
**Author:** [@neelimaj](https://forum.cloverdx.com/u/neelimaj)\ **Replies:** 2\ **Last updated:** [May 6, 2024, 12:00am UTC](https://forum.cloverdx.com/t/upload-pdf-document-to-external-system-through-an-api/2158 "2024-05-06T00:00:00Z")
Hi, We have a requirement to send document to external system through a POST API call… Could someone help with the configuration of it in case of a pdf file. --- ## [Creating a new record (row) transformation help](https://forum.cloverdx.com/t/creating-a-new-record-row-transformation-help/2157)
**Author:** [@Mahmood\_Babalola](https://forum.cloverdx.com/u/Mahmood_Babalola)\ **Replies:** 1\ **Last updated:** [April 14, 2024, 12:00am UTC](https://forum.cloverdx.com/t/creating-a-new-record-row-transformation-help/2157 "2024-04-14T00:00:00Z")
I have a transformation i am trying to acheive but can’t figure out the logic to do it, can somebody please help me CLASS is an input, and from it i am removing the last three digs using this code that works well. " if… --- ## [Postcode validation](https://forum.cloverdx.com/t/postcode-validation/2156)
**Author:** [@Anouk\_Cederboom](https://forum.cloverdx.com/u/Anouk_Cederboom)\ **Replies:** 1\ **Last updated:** [March 13, 2024, 12:00am UTC](https://forum.cloverdx.com/t/postcode-validation/2156 "2024-03-13T00:00:00Z")
Hi, I have a list of customers for which I’d like to check if the postcodes are valid based on a regular expression. The only thing is that my list of customers contains customers from all over Europe. I started of by … --- ## [Write field names in a data app when downloading file as CSV](https://forum.cloverdx.com/t/write-field-names-in-a-data-app-when-downloading-file-as-csv/2155)
**Author:** [@Brandon\_Russell](https://forum.cloverdx.com/u/Brandon_Russell)\ **Replies:** 2\ **Last updated:** [February 12, 2024, 12:00am UTC](https://forum.cloverdx.com/t/write-field-names-in-a-data-app-when-downloading-file-as-csv/2155 "2024-02-12T00:00:00Z")
I have a data app and enabled download as CSV, but it does not contain the header rows after downloading. I see that if you select other output options like JSON or XML, the headers are there but I don’t see an option to… --- ## [Concat string fields in various rows to a single row](https://forum.cloverdx.com/t/concat-string-fields-in-various-rows-to-a-single-row/2154)
**Author:** [@Fabien\_Carrion](https://forum.cloverdx.com/u/Fabien_Carrion)\ **Replies:** 1\ **Last updated:** [January 17, 2024, 12:00am UTC](https://forum.cloverdx.com/t/concat-string-fields-in-various-rows-to-a-single-row/2154 "2024-01-17T00:00:00Z")
Hello, I was expecting the aggregator step transform to be able to concat a string field and give back only one big string. How could I achieve that? Thanks --- ## [EmailReader simply not working](https://forum.cloverdx.com/t/emailreader-simply-not-working/2153)
**Author:** [@Martin\_Thomas](https://forum.cloverdx.com/u/Martin_Thomas)\ **Replies:** 1\ **Last updated:** [January 15, 2024, 12:00am UTC](https://forum.cloverdx.com/t/emailreader-simply-not-working/2153 "2024-01-15T00:00:00Z")
Hi, I’m quite new to CloverDX and simply try to use an EmailReader but it doesn’t work. I used the EmailReader | CloverDX 6.3.0 Documentation to create the job on a 6.2.0.14 Designer. The job kind of starts but finishe… --- ## [Powershell and SysExecute on Designer](https://forum.cloverdx.com/t/powershell-and-sysexecute-on-designer/2152)
**Author:** [@uykusuzzzz](https://forum.cloverdx.com/u/uykusuzzzz)\ **Replies:** 2\ **Last updated:** [January 3, 2024, 12:00am UTC](https://forum.cloverdx.com/t/powershell-and-sysexecute-on-designer/2152 "2024-01-03T00:00:00Z")
Hello, I need to run some powershell code on Windows using designer systemexecute. This works fine if I get the script to a file and then run it via Powershell.exe -File “” but ideally I want to type the PS script into … --- ## [Email sender multiple attachments](https://forum.cloverdx.com/t/email-sender-multiple-attachments/2151)
**Author:** [@chris582](https://forum.cloverdx.com/u/chris582)\ **Replies:** 1\ **Last updated:** [December 21, 2023, 12:00am UTC](https://forum.cloverdx.com/t/email-sender-multiple-attachments/2151 "2023-12-21T00:00:00Z")
I am trying to attach multiple files to an email within the email sender component. I have a variable list of files that need to be attached going into the email sender component, and have mapped the file URLs in the att… --- ## [CloverDX Handling Big Data and Files](https://forum.cloverdx.com/t/cloverdx-handling-big-data-and-files/2150)
**Author:** [@CloverDxNewBie](https://forum.cloverdx.com/u/CloverDxNewBie)\ **Replies:** 1\ **Last updated:** [October 25, 2023, 12:00am UTC](https://forum.cloverdx.com/t/cloverdx-handling-big-data-and-files/2150 "2023-10-25T00:00:00Z")
Dear Forum Members, We are planning to use cloverDX graphs to ingest files approx. 40-45 files on a daily basis, each files may contains 1000-30000 rows. Can CloverDX handles this? Is there any documentation where you c… --- ## [Continue JobFlow If A Single Node Fails](https://forum.cloverdx.com/t/continue-jobflow-if-a-single-node-fails/2149)
**Author:** [@hesske](https://forum.cloverdx.com/u/hesske)\ **Replies:** 2\ **Last updated:** [October 23, 2023, 12:00am UTC](https://forum.cloverdx.com/t/continue-jobflow-if-a-single-node-fails/2149 "2023-10-23T00:00:00Z")
I have a jobflow that has a DeleteFiles component in the first phase. Sometimes, there is no file for this component to delete which will cause the component and the jobflow to fail. Is there a way to have the jobflow co… --- ## [Creating sequence for a row - RowID](https://forum.cloverdx.com/t/creating-sequence-for-a-row-rowid/2147)
**Author:** [@CloverDxNewBie](https://forum.cloverdx.com/u/CloverDxNewBie)\ **Replies:** 3\ **Last updated:** [October 23, 2023, 12:00am UTC](https://forum.cloverdx.com/t/creating-sequence-for-a-row-rowid/2147 "2023-10-23T00:00:00Z")
Dear Support, is there any example to generate sequential values and assigning it to row as row id after sorting the data, for example: Item ItemColor Location Order Prod 1 Blue Web 1 Prod 2 Red Web 1 Prod 2 … --- ## [How to reset clover pay box without email or password?](https://forum.cloverdx.com/t/how-to-reset-clover-pay-box-without-email-or-password/2148)
**Author:** [@Drew](https://forum.cloverdx.com/u/Drew)\ **Replies:** 1\ **Last updated:** [October 17, 2023, 12:00am UTC](https://forum.cloverdx.com/t/how-to-reset-clover-pay-box-without-email-or-password/2148 "2023-10-17T00:00:00Z")
I recently bought a warehouse which included a lot of various items, and one of the items was a clover payment box, it has a password on it and i cant reset it [Previous page](https://forum.cloverdx.com/latest.md) [Next page](https://forum.cloverdx.com/latest.md?page=2)