Dynamic Data Load Activity

[vikas_nagabhushana]

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:  

Next runs: 

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

[Craig_Thonis · Accepted solution]

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

[Deb_Tripathy]

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