BookmarkSubscribeRSS Feed
89sankar
Fluorite | Level 6

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

4 REPLIES 4
LinusH
Tourmaline | Level 20
Please elaborate. Give an example, and tell how you would like to use this information.
Data never sleeps
Patrick
Opal | Level 21

Please also provide the DIS version.

89sankar
Fluorite | Level 6

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
LinusH
Tourmaline | Level 20

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

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1560 views
  • 1 like
  • 3 in conversation