How to define the schema column which to be exported in the package?

Avatar

Avatar

yueminspb

Avatar

yueminspb

yueminspb

23-11-2020

Hi Team I just encountered a issue. I have defined a schema, but when I want to export the data of this schema to a new environment, we found that some important column of data is lost. If there any configuration to define which column should be exported?

this is my schema definition

yueminspb_0-1606267179880.png

package defined as below

yueminspb_1-1606267263825.png

but in the exported package, only three column be exported

yueminspb_2-1606267385117.png

 

 

Accepted Solutions (0)

Answers (3)

Answers (3)

Avatar

Avatar

Sukrity_Wadhwa

Employee

Avatar

Sukrity_Wadhwa

Employee

Sukrity_Wadhwa
Employee

01-12-2020

Hi @yueminspb,

Were you able to resolve this query with any of the given solutions or do you need more help? Do let us know.

Thanks!

Avatar

Avatar

wodnicki

MVP

Avatar

wodnicki

MVP

wodnicki
MVP

24-11-2020

Hi,

 

Export the data? Use File extract activity in a workflow, then use web browser or sftp to pick up the file.

 

Thanks,

-Jon

Avatar

Avatar

Milan_Vucetic

MVP

Avatar

Milan_Vucetic

MVP

Milan_Vucetic
MVP

24-11-2020

Hi @yueminspb 

use package definition to select schema and then make an export. All columns will be there.

In case you are using direct export from the schemas folder you are able to remove XML lines before export and this probably happened here.

Regards, Milan