Reading data from csv with data in the multiple rows

[sriniprad08]

Hi Team,

I need help. I have a situation where i have csv file with column names in single row but data is spread across two rows. I need to bring the second row of data in the same line as first row .

ideally the yyy should be part of xxx and the "0";"0";"0";"30" should be in the next column.

id;"vse_id";"vse_id";"vse_date_created";"vse_date_planned";"vse_priority_id";"vse_object_id";"vse_creator_id";"vse_dt_id";"vse_desc";"vse_recur_interval";"ese_last_instance";"vse_external_id";"vse_changer_id"

41;"41";"1";"2004-05-24 07:07:30";"2004-06-04 00:00:00";"3";"2908";"30";"1";"xxx

yyy";"0";"0";"0";"30"

[sriniprad08]

@atcodedog05 

[atcodedog05]

Hi @sriniprad08 

Since this is unchecked

It should work as expected

And my workflow should work even if there is spillage in multiple rows also (i,e 1st row is intact but 2nd row is spilled into multiple rows)

[sriniprad08]

Thank you @atcodedog05  I am getting an error it says can't find the text. how should i modify it pleaes?

[atcodedog05]

Hi @sriniprad08 

First thing : you dont need yo groupby in multirow formula tool.

Second thing :  Text is the column name. I thing you can do it use a select tool and rename the column you want to work on as Text.

It should work.

Third thing :  i can see you are using excel file i hope you have configured to read from first row.

Hope this helps 🙂

[sriniprad08]

Thank you @atcodedog05  . I followed what you said. But it's not working means not getting the desired output.. May be i am missing something simple. Your logic is perfectly fine. Do i need to change any formula.?

[sriniprad08]

Hi @atcodedog05 

This is the sample file.

Can you please help?

Thanks,

S

[atcodedog05 · Accepted solution]

Hi @sriniprad08 

Sorry for the delayed response i was away.

I am using @jdunkerley79 's amazing method.

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[sriniprad08]

Hi @atcodedog05  Thank you. Great solution. However my data has some serious problems. This workflow is not working there.

Thank you againfor your time,

Cheers,

Srin

[atcodedog05]

@sriniprad08 

Sure let me know how i can help you further🙂

[atcodedog05]

@sriniprad08 

Feel free to reply back or reach out if you face any more issues. If i am available i will try my best to help you out 🙂