Date changed after I transpose table

[helpplease]

After I transpose the table on the left, the date changed. How do i change it back to the format in column A?

[mkankatala (Mahesh Kankatala)]

Hi @helpplease

When you are using read range workbook activity before transpose data. In the properties of read range workbook activity check the preserve format option it will give the same datatype format in the datatable.

Hope it helps!!

[supermanPunch (Arpan)]

Hi @helpplease ,

Could you let us know what was the Transpose method used ?

[helpplease]

LINQ | Transpose Datatable Uipath | LINQ Transpose Datatable | Uipath Tutorials | Coderslobby

^this video

[helpplease]

[rlgandu]

@helpplease

dt.AsEnumerable().ToList().ForEach(Sub(row) row(0)=DateTime.ParseExact(row(0).ToString.Trim,“d/mm/yyyy ”,System.Globalization.CultureInfo.InvariantCulture).ToString(“MMMM yyyy”))

[supermanPunch (Arpan)]

@helpplease ,

In that case, Could you try using PreserveFormat option as True when using Read Range activity.

You can find it in Read Range activity properties.

Let us know if it does not work.

[helpplease]

it didn’t work. Only the $ spent values moved from the align right to align left

[supermanPunch (Arpan)]

@helpplease

it didn’t work. Only the $ spent values moved from the align right to align left

@helpplease ,

Could you add an Additional string ' when creating the Column names for the Transposed Datatable.

[helpplease]

Thank you, it worked. Why adding ’ , will help solve the issue?

[supermanPunch (Arpan)]

@helpplease

Why adding ’ , will help solve the issue?

@helpplease ,

The representation in Excel is different when used Date values, It automatically recognises it as a Date value, and the default date representation (MM/dd/yyyy) is shown in the Excel.

[helpplease]

ok, thank you for the explanation.