Multiple Row to single row from imported file? | Community
Skip to main content
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by ParthaSarathy

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

 


@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.

2 replies

ParthaSarathy
Community Advisor
ParthaSarathyCommunity Advisor
Community Advisor
June 12, 2024

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

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    P
    PawanGuAuthor
    Level 2
    June 12, 2024

    Hi @parthasarathy ,

     

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

     

    Thanks 

    Pawan

    P
    PawanGuAuthor
    Level 2
    June 13, 2024

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


    Hi @parthasarathy 

     

    Please update me.

     

    Thanks

    Pawan Gupta 

    P
    PawanGuAuthor
    Level 2
    June 12, 2024

    Hi @parthasarathy ,

     

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

     

    Thanks

    Pawan

    Terms & ConditionsAccessibility statement

    Loading footer...