7b381a06-0fb7-4a05-90c0-04f1899e9d92.jpg

Novigo Solutions is an end-to-end IT Solutions provider, specialized in full cycle IT Services and platform solutions

Developer

e6653b86-6191-494c-b705-57f8d49ea57c.png

The component has two input arguments and one output argument. 

  

The input arguments are:

*    **in\_DataTable**: A datatable, the one which is to be converted into HTML table.
*   **in\_NeedBorder**: A boolean variable to decide if a border is needed for the HTML table or not.

Output:

*   **out\_HtmlTable**: The resulting output string will be a HTML table with or without borders as per the input boolean variable.

The component will convert a .NET datatable object in to a HTML table

This activity is capable of converting a data column with inconsistent date formats into a consistent or uniform format.

  

**Inputs:**

  

1\. DataTable: The data table variable which consists of a column having inconsistent date formatting (Doesn’t follow a uniform date formatting).

2\. ColumnName (of String): The name or index of the column to be standardized as a string.

3\. DateFormats: All the available string formats followed by the column have to be listed as an array of string.

4\. RequiredFormat: The uniform date format to which the column is to be converted.

  

**Outputs :**

  

1\. OutputTable: The output data table with the formatted output (The output datatable should preserve the schema of the input datatable).

  

2\. FormattingFailedIndexes: The row indexes for which the formatting has failed since a matching input date format was not found for those dates.

  

Please check the video URL attached with this upload if you have any doubts.

The activity finds a solution to the problem of DataTables with multiple date formats in the same column (of type string), by converting them to the same format

About me