310 questions
1
vote
1
answer
51
views
Dynamic column drop per file in Azure Data Factory Data Flow (no merge/union)
I have multiple CSV files in a folder, each with different columns.
I want to process each file in Azure Data Factory Data Flow so that:
Only certain columns (specified per file) are kept.
Unwanted ...
- 11
0
votes
1
answer
34
views
Add column name in temp table from different table and filter according that for those columns
In my stored procedure where I am generating report in the table Age, user can define date range for which date range data needs to be come. Table Age has AgeDesc, StartDay and EndDay. Please check ...
- 3,510
0
votes
2
answers
70
views
How to dynamically handle and display varying numbers of columns (e.g., drink ingredients) in C#?
I’m working on a project that fetches drink details from an API (TheCocktailDB). Each drink can have up to 15 ingredients and corresponding measurements, but the actual number of ingredients varies by ...
0
votes
1
answer
231
views
Filter doesn't work when dynamically added column on primereact DataTable
I'm trying implement dynamic DataTable from PrimeReact, but added new column doesn't have filter data.
On example, there is dropdown and you can add more columns to table, but added column filter ...
0
votes
1
answer
57
views
Error attempting to use dynamic columns in SQL Server stored procedure
I saw several posts on Stack Overflow describing how to use dynamic columns in a SQL Server stored procedure, but my attempts result in an error message regarding the dynamic column name I am trying ...
- 51
0
votes
0
answers
73
views
Matrix table whose columns are based on slicers selection, here more than one slicers will decide the columns of a table/matrix in power bi
I have to create a matrix whose columns are based on slicer selection.
Scenario
Table having a columns product type, attribute and values.
Slicer 1 has product type, slicer 2 has again same column ...
- 66
0
votes
1
answer
518
views
How to make editable dropdown lists dynamic based on rowData?
I'm trying to vet AG Grid for a project I'm working on to see if it will cover all of our needs and I'm getting stuck on a feature that seems like it should be fairly straightforward. In my rowData ...
0
votes
1
answer
36
views
How to create stacked column chart using highchart.js with dynamic values
Table
:
Array(4)
0
:
{MonthsName: 'April', AUTOLIV: 0, Continental: 0, Herman miller: 0, REL: 0, …}
1
:
{MonthsName: 'July', AUTOLIV: 0, Continental: 4, Herman miller: 0, REL: 0, …}
2
:
{MonthsName: '...
- 21
0
votes
1
answer
616
views
Azure Data Factory Get Metadata activity returning "(404) not found" error when getting column count
I am trying to implement a Get Metadata activity to return the column count of files I have in a single blob storage container.
Get Metadata activity is returning this error:
Error
I'm fairly new to ...
0
votes
2
answers
1k
views
Copy CSV file data from blob storage to Azure SQL database based on the number of columns in the file
I have data files landing in a single Azure blob storage container every other day or so. These files have either 8, 16, 24, or 32 columns of data. Each column has a unique name within a file, and the ...
3
votes
0
answers
614
views
How can I remove column filters from a table in Antdesign on programmatical removal of columns?
In a ReactJS application (Typescript), using Antdesign 4.12.2, I am building a table that shows a list of record data over a number of columns. The columns shown can be modified by adding or removing ...
- 31
1
vote
1
answer
64
views
Having issues with CSV files with columns that should be simply ignored, irregulat formating
We have a series of datafiles that are a rectangle of data that someone exports from Excel. Sometimes they export extra columns that are blank entirely. 1, 2, 15. We don't want those columns OR ...
- 11
0
votes
0
answers
200
views
Using dynamic arrays as column types in psql
Currently we are planning a new feature that will get several new tables. In summary, its a time series optimization so we split it up into different tasks and store the intermediate results in tables....
- 197
0
votes
1
answer
70
views
Add formulas to specific cells
I'm creating a macro where I could apply my formulas to selected column (this is the working month-year, example Nov-2022). I have initial code where the specific column for that month will be ...
1
vote
0
answers
420
views
How To Implement Dynamic Columns in Django models based on POST request
I have created a Django RestFramework with few models like Offers, Dailysubs and Requisitions to which I need add columns dynamically for a POST request.
There should be 1-10 blank columns for a model ...
- 11
0
votes
1
answer
236
views
How to get the sum of the filtered data in shinyapp
I'm trying my first shinyapp using two filters. The output would be two; the first to get a data table and the second to get the sum of the filtered output.
The data consists of 4 variables;
...
0
votes
1
answer
414
views
Create a table with column names dynamically retrieved from a single-column query result
I have a select query that returns a single column. Is there a way in sqlite to create a new table using the results as column names?
I tried query but it did not work.
CREATE TABLE newTable (SELECT ...
- 130
0
votes
1
answer
30
views
Columns lining up with content
I have come across a problem, I can only use CSS and HTML. But for this I will give a basic layout that I have found.
The plan is to use this code instead of making the columns with (Min-height) (...
- 13
0
votes
1
answer
1k
views
Query/filter out blank non-specified columns from range
I would like this multiple-criteria query not to show empty columns.
=QUERY({H3:M11}, "select * WHERE
"&TEXTJOIN(" and ", 1,
IF(C3<>"", "Col2 = "&...
- 39
0
votes
0
answers
26
views
SQL query return rows to columns dynamically [duplicate]
I have one table as job_status which is having columns as date, status
here is the query which i prepared
SELECT DATE_FORMAT(date,'%D %M %Y') DATE, status STATUS,
COUNT(*) COUNT
FROM job_status
where ...
- 329
1
vote
2
answers
60
views
sql group where clause
I have a table like this:
| grpType | grpId | paramId | val |
|---------|--------|:-------:|------:|
| 0 | 81452 | 123 | 1,293 |
| 0 | 81452 | 127 | 46 |
| 2 | 19873 ...
0
votes
2
answers
1k
views
Laravel 8.83: Dynamic columns in table
In the application, we have 2 modules called "Type" and "Lists".
When the user created in type, it will be display in the creating of lists.
For example
There's 2 data in type: ...
- 989
0
votes
1
answer
781
views
Creating Dynamic Columns in Power Query with Expression Lookups
I have a Source file that has a set of columns, each of binary type (true, false). I then have a processing (transform) table which has one or more rows, each row specifying a new column to be added ...
0
votes
1
answer
467
views
Add column based on condition in SQL
I have 3 columns with values ranging from 0.1 to 0.9.
I want to create a calculated field in sql which would give an output 'Y' if any of the 3 columns has a value greater than 0.8, if not the output ...
- 31
0
votes
0
answers
416
views
Change grouping column based on slicer selection - Power BI
I have a data set and a mapping table as below.
In Power BI, I created a slicer dropdown containing words "Finance Lens" and "Business Lens", This is created using table "...
- 4,670
0
votes
1
answer
578
views
Variable padding with printf and csv file
I'm aware that there are a lot of similar questions but I can't find an answer that relates to my particular use case, though I'll admit that this may be due to my lack of understanding more than ...
- 1
0
votes
1
answer
132
views
Number Formatting Dynamic columns in SSRS
I've been picking this one up and putting it down for a few months now and have spent several hours on trying to figure out how to set up the right expression. I have a dataset that is dynamic based ...
0
votes
1
answer
627
views
Column with fixed aspect ratio in two column flex layout
I need an image (image container to be precise) to resize according to container height and maintain its aspect ratio. Longer the text = bigger the image. Right now its ether image getting out of ...
- 483
0
votes
3
answers
2k
views
Create Dataframe Columns Automatically with Different Names
How can I create dataframe columns automatically with different names
I have this code
df=pd.DataFrame(columns=['A']*5)
df.loc[len(df)]=[1,2,3,4,5]
Which gives the result
A A A A A
0 1 2 3 ...
- 15k
0
votes
1
answer
806
views
Create a column in power Bi Based upon selection
Recently I came up with this problem:
I have a table with two different codes: COD1 and COD2. I want to create in power bi bar charts and tables with this information but I want to be able to change ...
0
votes
1
answer
12k
views
Create a column with dynamic values based on selected value of slicer
Power BI enthusiast
I am new to Power BI.
I have an issue with details as following:
I have a table called dw_xyz:
ID
Shape
Color
Value
1
Circle
Blue
10
2
Triangle
Red
23
3
Rectangle
Blue
20
4
...
- 43
0
votes
0
answers
2k
views
Select dynamic columns with names from another table
I have 2 tables, one containing IDs and data attributes and another containing Attribute descriptions.
What I need to do is to read the ID and all Attribute columns (needs to be dynamic, as they could ...
- 187
0
votes
1
answer
242
views
How can create a table while Execute dynamic @Query
I have a dynamic query in my sp which has different columns related to the inputs that user will enter. After that, In sp I want to join the result of it to the remaining part of sp. So I should have ...
- 378
0
votes
0
answers
280
views
How to split a pyspark dataframe based on a column value
I have a below sample data frame.So the data from first roll no to mobile number is data of a student and the data from next roll no to email is data of some other student. And so on. In nut shell I ...
- 111
1
vote
1
answer
196
views
Dynamically grab a specific column from a joined table
I have a very complex query pulling data from almost 10 tables already and growing, and I need to achieve something unusual. The main table (the FROM table) has a field named SIZEPOS, which is an ...
- 724
0
votes
1
answer
2k
views
Excel Text to Columns in VBA with variable number of delimiters in each row?
I am processing instructor evaluations for a college in an Excel file. One row represents one course section and contains all student comments for that section. The number of comments may be anywhere ...
- 5
0
votes
1
answer
4k
views
How to get dynamic table header from an array in react?
I am trying to loop out an array from part of the data I got, into my Table header. I use material-UI Table.
The retrieved data looks like this:
0: {baseclass_id: 1, sortOrder: 1, …}
1:
baseclass: {...
- 43
0
votes
1
answer
2k
views
How to use variables as pivot columns on SQL Server
I am having an issue making a table with pivot columns more dynamic on MS SQL Server.
I have a query that retrieves data from a five week period of the current year and a five week period of the ...
- 21
0
votes
0
answers
109
views
SQL Server Dynamic Column's
I want to create an app like asana which has a dynamic column
Add Field option in ASANA
I don't want to use NO-SQL.
The idea is like in mariadb dynamic-columns
create table assets (
item_name ...
5
votes
1
answer
75
views
Dynamic Column Index Name Error in Formula
I am trying to calculate the component q'ty from Sheet Plan to Sheet Result by using Vlookup to fill in column,having:
Count_col: is the total column in sheet Plan
Last_col: is the total column in ...
- 123
0
votes
1
answer
83
views
Is there any function that can change the column names dynamically as per filter changes in Tableau CRM
Is it possible changing the columns dynamically in Tableau crm lens as per filter changes.?
0
votes
0
answers
159
views
Merging cells in column level by using DataGridCell.Margin property
I have custom DataGridTemplateColumn. I'm trying to merge the column in RowSizeChangedEvent by setting the margin.
I have few rows and some of the rows will be duplicated. I would like to merge those ...
- 305
0
votes
1
answer
2k
views
In flutter how to create dynamic column and row both (according to data column ) in datatable
In Flutter I Want to dynamic column in my Data Table because from database every time I get different number() of column.
how I create Anyone help
0
votes
1
answer
661
views
Python: Referencing a column in DataFrame using a function
This is the code that I have:
.......
gender = data.loc[np.where(data['ID']==id)]["gender"].tolist()[0]
cell = data.loc[np.where(data['ID']==id)]["cell"].tolist()[0]
bloodtype = ...
- 345
2
votes
2
answers
582
views
MariaDB NoSQL data using dynamic columns or JSON
I want to store dynamic statistical data in a NoSQL way - a structured document and be able to work on a parameter basis.
e.g.
{
'client': 1245,
'amount': 25425,
'create_date': '2019-01-01'
}
...
- 400
-1
votes
1
answer
2k
views
css grid template column elementor make 2 / 1
I want to make ordering as on my photo.
I maded blog page with elementor and need to change with css grid template column.
Code is:
.elementor-grid-2 .elementor-grid {
grid-template-columns: ...
-2
votes
1
answer
39
views
How to make a list view builder inside a Row inside a column
I would like to add a row holds containers using [list view builder] and when the row holds 3 containers , the next container go to another row { i mean that [column [has a row [has containers of max ...
0
votes
2
answers
4k
views
Power BI matrix - Subtract two (dynamic) corresponding columns using DAX
I have a single measure in the Power BI Desktop matrix below.
The measure comes from a single table, and is a sum of a column with numerical values.
The measure is: SUM(Table[Column])
Column ...
- 465
1
vote
1
answer
1k
views
Oracle - Table function that returns dynamic column names
I'm building a report that should generate a dynamic list of columns based on the requested years, i.e. 2000 to 2002. The user should be able to run the report via a SELECT statement like so:
SELECT *...
- 3,821
-1
votes
2
answers
891
views
How should I create a table with dynamic column width by importing data from an excel file using tkinter Python?
I want to import all data(headers, columns, rows) from an any sample MS Excel spreadsheet to a tkinter frame. I have tried to do it but didn't work. Can someone help me with this task ? Thank you!
...
- 27