Shuffle rows - CSV to Excel - Using datatable

[Selvasathappan (Selva)]

Hello,

When I try to convert a CSV to excel file using datatable approach, is it possible the rows might be shuffled? And even my headers are only appearing at the bottom? Is there any reason to this?

What I did - Steps

1. Read csv to read the csv file
2. store the output in datatable dt1
3. use excel application scope
4. write range to write the output to a new excel sheet

However when I see the output excel, data is generated but in random order. Is it possible? Moreover my headers are displayed as a last row. Why do you think this is happening?

[quihan]

Hi @Selvasathappan, why not use read excel to read your excel file at the first step?

Cheers.

[Selvasathappan (Selva)]

Sorry, I am using read csv to read csv file in the first step

[quihan]

hi @Selvasathappan, it should be the same sequence as your csv. May I get a screenshot of your csv file?

[Selvasathappan (Selva)]

Hello Quihan,

Thanks for the response. However before I could try the earlier issue, I had to work on other task. Can you please help me with the below task? I am struggling to get this right with limited knowledge in .net

Real time Business Logic - Excel Summation based on rows using identifier

Hello Everyone, I would like to verify whether client records grouped based on an unique identifier tallies with bank record. For example, in the below screenshot, records highlighted green indicate “Bank” records and can be identified using “BK” term in the string. Whereas non highlighted records are client(customer) records. In the example below, I would like to verify whether records grouped by KID tallies with their respective bank record. For example : Records grouped by A1 would result …

[quihan]

Hi @Selvasathappan, I think there are some suggested solutions at your previous post.
Cheers

[Selvasathappan (Selva)]

@quihan - Hello quihan, can you help me with this?

Unable to read CSV - Invalid format

Hello Eevryone, I am not able to read a csv file using “Read CSV” operator. It throws an error message as “Invalid format” However I was able to open other CSV files earlier. The only difference between the CSV file which threw error and the other one is the date format. File read successful - had date format in DD.MM.YYYY File read failure - had date format in DD/MM/YYYY. How can I read CSV with the date format as is. Even if I have to make manipulation to the data, I have to read to make …

[Selvasathappan (Selva)]

@quihan - Can you please help me with this?

Sort random - Datatable

Hello Everyone, Is there a way to sort the datatable in a random order? I mean I would like to shuffle the rows of my datatable. Can anyone please help me? I don’t want it follow any order like ascending/descending. I want to induce randomness to the data order. Please note am using version 2017.1.6682. There is no filter datatable activity as such. I usually use select clause for that but how do we do it when we want the data to be in random order?