Multiple Row to single row from imported file?

[ParthaSarathy]

Hi @PawanGu ,

If your file is a .csv file, enable 'Comma' in 'Column Separator' in data loading activity > click here to change the file format

[PawanGu]

Hi @ParthaSarathy ,

I am doing same but not getting above output. Can you please share steps and output screen shots.

Thanks 

Pawan

[ParthaSarathy]

@PawanGu  Share us your sample file structure and 'click here to change file format' configuration and the error detail

[PawanGu]

Hi @ParthaSarathy ,

Can you please show me multiple steps those you use.

Thanks 

Pawan

[PawanGu]

Hi @ParthaSarathy ,

I am used your solution and get all column merged in to single column but I need all colunn row merge in single row with colon separator as my input and output layout. Please provide a quick solution.

Thanks

Pawan gupta

[PawanGu]

Hi @ParthaSarathy 

Please update me.

Thanks

Pawan Gupta 

[ParthaSarathy]

@PawanGu ,

If you open your .csv file in notepad, it should be like this

Create a new Data loading (file) activity, and when you upload this sample file, you can see the below structure by default

Now, select 'click here to change the file format', have the same configuration as below,

When you upload the file and run the workflow, you will receive the output as below,

Whereas, if you configure as below in 'click here to change the file format', by not selecting any in 'column separator'

you will be getting output as,

[PawanGu]

Hi @ParthaSarathy ,

Thanks for 

So I want single column rows data merged in single row with colon separator. Please  suggest as per my issue.

Thanks for your overall support.

Pawan

[ParthaSarathy · Accepted solution]

@PawanGu , This can't be done in Data loading activity. It will consider each row of the file as a individual data row in the temporary work schema.

[PawanGu]

Hi @ParthaSarathy ,

Is there any other activity to get same result.

Thanks

Pawan 

[PawanGu]

Hi @ParthaSarathy ,

I am getting error when run campaign given same you provide solution. Please provide solution.

Thanks

Pawan