Kimball ETL (subsystem 1) – Data Profiling via TSQL

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

UKGav Say Hey Kid Points: 678 More actions · Answer 1

Ok so this is cool to profile a column, but... 🙂

How could this be run/changed to return multiple rows for each column in a table?

~ UKGav

Ira Warren Whiteside SSCrazy Points: 2146 More actions · Answer 2

Thanks for the comment, the script as is will do all multiple columns in a tables based on filter.

[font="Comic Sans MS"]Ira Warren Whiteside[/font]

Ira Warren Whiteside SSCrazy Points: 2146 More actions · Answer 3

Sorry I should have noted the filters support wildcard, just put in a % character.

SET @columnname ='%'

[font="Comic Sans MS"]Ira Warren Whiteside[/font]

UKGav Say Hey Kid Points: 678 More actions · Answer 4

I tried that and it didn't work.

I didn't expect it to work either as = '%' is not valid SQL, it would need to be LIKE '%' but that isn't valid in a SET statement.

Or am I missing something?

- UKGav

Ira Warren Whiteside SSCrazy Points: 2146 More actions · Answer 5

Sorry, too many scripts, you are right, send me an email iwhiteside@iwhiteside.com and I will send you the multi column version.

[font="Comic Sans MS"]Ira Warren Whiteside[/font]

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 6

SSC Guru

Points: 76202

May 10, 2016 at 9:28 am

Thanks for the script.