Solved

How to export columns dynamically in the Data Extraction activity??

3 replies
1600 views
Translate All

i have a requirement where based on a condition certain columns needs to be exported into file in the data extraction activity.

I found that in the Edit XML of column export we have a node - exportcolumn where active= "true" for the selected columns (attached screenshot below). Can you provide how to go and edit the edit source to change the field active = "false"??

Please provide any alternative solution if any.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Jonathon_wodnickiAccepted solution

Community Advisor

Hi,

I haven't used that tab, which is probably there for post-activity scripting.

You want to alter the activity's config in the init script under Advanced tab- path is activity.extraction.select.

Thanks,

-Jon

Jonathon_wodnicki

Community Advisor

Hi,

Export the workflow, alter it in notepad, import it.

Thanks,

-Jon

Translate

S

sparshg21051243Author

Hi,

Actually i need to automate this process, as such whenever my filecode(column value) changes, i want certain columns to be selected for exporting. Can we do this process automated? Is there any other way to change the columns which needs to get exported?

I see an export modification script tab in the data extraction activity. Can you please let me know the use of it??

Thanks,

Sparsh

Translate

Jonathon_wodnicki

Accepted solution

Community Advisor

Hi,

I haven't used that tab, which is probably there for post-activity scripting.

You want to alter the activity's config in the init script under Advanced tab- path is activity.extraction.select.

Thanks,

-Jon

Translate

Sign up

Login with SSO

Login to the community

Login with SSO