Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Importing data in multiple tables

Avatar

Avatar
Applaud 5
Level 1
rohanpat
Level 1

Likes

0 likes

Total Posts

29 posts

Correct Reply

0 solutions
Top badges earned
Applaud 5
View profile

Avatar
Applaud 5
Level 1
rohanpat
Level 1

Likes

0 likes

Total Posts

29 posts

Correct Reply

0 solutions
Top badges earned
Applaud 5
View profile
rohanpat
Level 1

10-06-2020

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.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 50
Employee
Adhiyan
Employee

Likes

239 likes

Total Posts

342 posts

Correct Reply

124 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile

Avatar
Boost 50
Employee
Adhiyan
Employee

Likes

239 likes

Total Posts

342 posts

Correct Reply

124 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile
Adhiyan
Employee

12-06-2020

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

Answers (3)

Answers (3)

Avatar

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

163 likes

Total Posts

380 posts

Correct Reply

134 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

163 likes

Total Posts

380 posts

Correct Reply

134 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile
Milan_Vucetic
MVP

11-06-2020

Hi @rohanpat ,

 

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

Avatar

Avatar
Give Back 25
MVP
Venu_Reddy
MVP

Likes

162 likes

Total Posts

171 posts

Correct Reply

53 solutions
Top badges earned
Give Back 25
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Give Back 25
MVP
Venu_Reddy
MVP

Likes

162 likes

Total Posts

171 posts

Correct Reply

53 solutions
Top badges earned
Give Back 25
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
Venu_Reddy
MVP

11-06-2020

Hi @rohanpat ,

 

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.

 

 

Avatar

Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

128 likes

Total Posts

140 posts

Correct Reply

43 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile

Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

128 likes

Total Posts

140 posts

Correct Reply

43 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
MVP

11-06-2020

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