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

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

Avatar

Avatar
Validate 10
Level 1
yueminspb
Level 1

Likes

0 likes

Total Posts

38 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
View profile

Avatar
Validate 10
Level 1
yueminspb
Level 1

Likes

0 likes

Total Posts

38 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
View profile
yueminspb
Level 1

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
Validate 500
Employee
Sukrity_Wadhwa
Employee

Likes

134 likes

Total Posts

821 posts

Correct Reply

35 solutions
Top badges earned
Validate 500
Validate 250
Validate 100
Validate 25
Validate 50
View profile

Avatar
Validate 500
Employee
Sukrity_Wadhwa
Employee

Likes

134 likes

Total Posts

821 posts

Correct Reply

35 solutions
Top badges earned
Validate 500
Validate 250
Validate 100
Validate 25
Validate 50
View profile
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
Contributor
MVP
wodnicki
MVP

Likes

941 likes

Total Posts

1,061 posts

Correct Reply

499 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile

Avatar
Contributor
MVP
wodnicki
MVP

Likes

941 likes

Total Posts

1,061 posts

Correct Reply

499 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile
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
Contributor
MVP
Milan_Vucetic
MVP

Likes

164 likes

Total Posts

382 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

164 likes

Total Posts

382 posts

Correct Reply

134 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile
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