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

Dynamic Data Load Activity

Avatar

Avatar
Level 1
vikas_nagabhushana
Level 1

Likes

0 likes

Total Posts

6 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
vikas_nagabhushana
Level 1

Likes

0 likes

Total Posts

6 posts

Correct Reply

0 solutions
View profile
vikas_nagabhushana
Level 1

22-04-2021

Team,

 

Is there a way to handle a dynamic input file i.e., the attributes in the input file keeps changing for every run ?

 

Ex:  

vikas_nagabhushana_0-1619138952815.png

 

Next runs: 

vikas_nagabhushana_0-1619139018162.png

 

vikas_nagabhushana_2-1619139062174.png

 

Data loading activity can handle a static file, so any pointers on how to handle a dynamic input file ? Is this even possible ?

 

Appreciate your responses.

Thank you

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Give Back 10
Employee
craigthonis
Employee

Likes

167 likes

Total Posts

258 posts

Correct Reply

152 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Boost 50
View profile

Avatar
Give Back 10
Employee
craigthonis
Employee

Likes

167 likes

Total Posts

258 posts

Correct Reply

152 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Boost 50
View profile
craigthonis
Employee

28-04-2021

Hi Vikas,

 

I would recommend submitting an enhancement as the data load activity doesn't handle file column changes automatically. The reason being is that it is expected that the data and file structure would be consistent in order to be able to insert this data into the database.

 

Regards,

Craig

Answers (1)

Answers (1)

Avatar

Avatar
Affirm 25
Level 4
Deb007
Level 4

Likes

50 likes

Total Posts

86 posts

Correct Reply

25 solutions
Top badges earned
Affirm 25
Boost 25
Applaud 5
Give Back 5
Validate 1
View profile

Avatar
Affirm 25
Level 4
Deb007
Level 4

Likes

50 likes

Total Posts

86 posts

Correct Reply

25 solutions
Top badges earned
Affirm 25
Boost 25
Applaud 5
Give Back 5
Validate 1
View profile
Deb007
Level 4

28-04-2021

Hi Vikas,

The Data Loading file doesn't support dynamic input file.

If the file structure and dynamicness is relatively simple, you may load all of it in one string column and the use logic in your workflow to separate them into different columns.

 

Cheers,

Deb