SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Filter or find columns in DI studio

Reply
Occasional Contributor
Posts: 10

Filter or find columns in DI studio

Can we filter or find a metadata column in 200 columns on DI studio?

Super User
Posts: 5,260

Re: Filter or find columns in DI studio

Please elaborate. Give an example, and tell how you would like to use this information.
Data never sleeps
Respected Advisor
Posts: 3,902

Re: Filter or find columns in DI studio

Please also provide the DIS version.

Occasional Contributor
Posts: 10

Re: Filter or find columns in DI studio

DI version 4.21 - below image. In mapping tab, If I want to search and update metadata of a single column. Is it possible?

 

Attached image has 186 columns, In some cases I have 500 columns.


mapping.png
Super User
Posts: 5,260

Re: Filter or find columns in DI studio

Perhaps you want to perform some kind of column metadata standardization?

Standardizing Column wizard was introduced in 4.3.

4.2 it's a very old release, I strongly advice to upgrade.

And 500 columns? Perhaps you need to refine your data model, which would probably reduce the need to maintain metadata/deployed jobs etc.

 

http://support.sas.com/documentation/cdl/en/etlug/68225/HTML/default/n0kw06lyyymqzin14dl0a1x9dtat.ht...

Data never sleeps
Ask a Question
Discussion stats
  • 4 replies
  • 244 views
  • 1 like
  • 3 in conversation