Importing data in multiple tables | Community
Skip to main content
rohanpat-1
Level 2
Jun 11, 2020 2:32 AM UTC
Solved

Importing data in multiple tables

For import, my custom MTA is dumping the data in text files, which I map to corresponding fields in adobe for insertion in broadlogrcp table. But I didn't find a way or option to have import / insertions in multiple tables at the same time. Could someone please let me know the steps or attach a snap pic for better understanding.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Adhiyan
AdhiyanAccepted solution
Employee
Jun 12, 2020 9:57 AM UTC

HI Rohan,

 

If you are using a workflow then before the update , use a Fork activity to split the incoming activity into multiple branches and load them in separate tables.


Regards,

Adhiyan

View reply

4 replies

Adhiyan
AdhiyanAccepted solution
Employee
Jun 12, 2020 9:57 AM UTC

HI Rohan,

 

If you are using a workflow then before the update , use a Fork activity to split the incoming activity into multiple branches and load them in separate tables.


Regards,

Adhiyan

Translate
    Milan_Vucetic
    Milan_Vucetic
    Level 9
    Jun 11, 2020 2:44 PM UTC

    Hi @rohanpat-1 ,

     

    this should be a quite possible in JS node.

    Create different mappings for different tables and execute insert with xtk.session.Write per table.

     

    Regards,

    Milan

    Translate
      Venu_Reddy
      Venu_Reddy
      Level 6
      Jun 11, 2020 1:03 PM UTC

      Hi @rohanpat-1 ,

       

      I'm not sure if there is an option to insert the data into multiple tables at a time and you can use alternate solutions.

      While importing there is only one possibility of selecting the destination schema and use split if the insertion fields are same in both the destination schema.

       

       

      Translate
      kapilKochar
      kapilKochar
      Level 6
      Jun 11, 2020 11:04 AM UTC

      Hi ,

       

      You have mentioned single table in your question. Can you please share more details or better a snapshot of your workflow where you trying to implement this logic. 

       

      Thanks,

      Kapil

      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...