How to add extracted data of two different workflow into one single file in SFTP | Community
Skip to main content
1
1994sagar
July 14, 2023
Solved

How to add extracted data of two different workflow into one single file in SFTP

  • July 14, 2023
  • 3 replies
  • 1286 views

I have two different workflows and I want to add extracted data of both these flows into one single file in SFTP folder. I have ran both the workflow in same time and put the same file output name, but still it is generating two different files in SFTP with same name. 

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 aggabhi

Hi @1994sagar ,

 

Giving same name to 2 different workflow files will not add up your data in one file in SFTP. Both workflows will generate two different files which are not dependent on each other even though you put the same file name, data will not add automatically.

 

I will recommend you to make a single workflow and before sending a file to SFTP, use Union to add the data with one file which has common layout of columns.

 

Let me know your use case of two different workflows, I can help combine 2 workflows into 1.

 

Regards

Abhishek

3 replies

A
aggabhiAccepted solution
Level 5
July 14, 2023

Hi @1994sagar ,

 

Giving same name to 2 different workflow files will not add up your data in one file in SFTP. Both workflows will generate two different files which are not dependent on each other even though you put the same file name, data will not add automatically.

 

I will recommend you to make a single workflow and before sending a file to SFTP, use Union to add the data with one file which has common layout of columns.

 

Let me know your use case of two different workflows, I can help combine 2 workflows into 1.

 

Regards

Abhishek

    ParthaSarathy
    Community Advisor
    ParthaSarathyCommunity Advisor
    Community Advisor
    July 14, 2023

    Hi @1994sagar ,

    You can try this way,

    In the end of both workflows, instead of using 'Extract file', use 'Save audience' activity and Label as 'File_1_data' in WKF1 and 'File_2_data' in WKF2

     

     

    Create a 3rd WKF (or in end of 2nd WKF), use 2 'Read audience' activity and call 'File_1_data' and 'File_2_data'. And union both this activity, then use Extract file and place it in SFTP. 

     

    Now you can see the single output file, which has the data of both WKF1 and WKF2.

     

    Supporting documents:

    Configuring 'Save audience'

    Configuring 'Read audience'

    ~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
      Sukrity_Wadhwa
      Community Manager
      Sukrity_WadhwaCommunity Manager
      Community Manager
      August 3, 2023

      Hi @1994sagar,

      Were you able to resolve this query with the help of the given solutions or do you still need more help here? Do let us know. In case the given solutions were helpful, then kindly choose the one that helped you the most as the 'Correct Reply'.
      Thanks!

      Sukrity Wadhwa
      Terms & ConditionsAccessibility statement

      Loading footer...