topic SQL dashboard report: Select table column dynamically in Data Engineering

SQL dashboard report: Select table column dynamically

pawank9 — Tue, 24 Jan 2023 21:13:47 GMT

I am using SQL Dashboard report, there are around 400 columns in a table, I want to display some of the columns based on data, not all 400 columns should be displayed.

eg: a table have column named c1, c2,c3,c4 and rows r1, r2, r3, r4. The report should show columns as per the below scenario,

case 1: for row r1, the report should dynamically show c1 and c2.

case 2: for row r2, the report should dynamically show c3 and c4.

case 3: for row r3, the report should dynamically show c1 and c4.

Note: consider the report is showing only one row for now.

Re: SQL dashboard report: Select table column dynamically

Hubert-Dudek — Wed, 25 Jan 2023 10:05:48 GMT

You can build own logic using query parameters, and/or just select required columns based on case.

Re: SQL dashboard report: Select table column dynamically

pawank9 — Wed, 25 Jan 2023 15:43:06 GMT

Hi, thanks for the response.

my requirement is to select columns dynamically not the query param.

I need to select columns based on data. hope the below example provides clarity:

eg: a table have column named c1, c2,c3,c4 and rows r1, r2, r3, r4. The report should show columns as per the below scenario,

case 1: for row r1, the report should dynamically show c1 and c2.

case 2: for row r2, the report should dynamically show c3 and c4.

case 3: for row r3, the report should dynamically show c1 and c4.