All Questions
91 questions
-1
votes
1
answer
117
views
How do I sort "SELECT INTO" queries that are built on top of each other by their "INTO" / "FROM" table links?
I need to migrate a dozen MS Access databases with 500+ queries to SSIS and therefore, I changed the code to TSQL, see How can I get TSQL from easy MS Access SQL with little to no handiwork?.
The ...
- 9,748
1
vote
1
answer
82
views
In a standard MS Access SQL query output that does not have any aliases, how do I replace the full names by their "first-letters" aliases?
I have a lot of queries from a bunch of MS Access databases. I read them out and split them into their SQL-blocks by the standard SQL keywords with:
How do I get the full sql code for all queries in ...
- 9,748
0
votes
0
answers
49
views
How to retrieve data from excel to postgres DB using python?
enter image description here
This is an image of my excel template, I need to retrieve data from it and fill my postgres table as shown in the picture, and the table code is:
CREATE TABLE public.test (...
0
votes
0
answers
37
views
How can I reorganize this sql data using either a better query statement or Pandas from Python? [duplicate]
How can I go about changing my current table/excel file to something that is grouped by school (row) and organized by month (column) and the cycle in the appropriate rowXcolumn cell? Would I have to ...
- 1
0
votes
1
answer
63
views
Inner Join Database Table with Excel file by query in python
I need to perform an inner join between a table in Amazon Redshift and an Excel table. The database table is quite large, and I only need to extract the IDs that are in Excel file, which contains a ...
- 331
-1
votes
1
answer
80
views
How to get multiplication of two column's value which is nearly equal (highest decimal) in the third column using SQL/Python?
I have a dataset named df
Multiplicating two columns (Open and low, which have the equal values) should give the result nearly equal to the highest integer (decimal) value referring to the 'High' ...
-1
votes
1
answer
54
views
Bar chart in tableau
I have 2 columns states and number of accidents, i want to create a bar chart with top 5 states with number of accidents. But with that i also want uttarakhand whether it comes in top 5 or not . How ...
- 1
-1
votes
2
answers
443
views
Is It Possible To Programmatically Clean This Data Using Python?
I'm looking for a quicker way to clean the data in a decent sized spreadsheet (between 5-15k rows) the issue I keep running into is that the data is in such poor shape its taking me ages to actually ...
- 35
0
votes
0
answers
51
views
How can I do a fuzzy left join across different reports?
Forgive me as this is probably going to be a crazy basic/broad question for you guys, but I'm extremely new to this role and trying to optimize some processes at work.
Here is the problem that I am ...
0
votes
2
answers
54
views
Selection of a condition by a range that includes strings (letter + numbers)
Please help. I have two tables: 1 report and 1 data file.
The data table is presented as follows:
PATIENTS_ID
POL
Age
ICD10
10848754
0
22
H52
10848754
0
22
R00
10848754
0
22
Z01
10848754
0
22
Z02
...
- 1
1
vote
1
answer
244
views
How to split an excel file into multiple sheets if it has more than 255 rows?
I have an excel file that contain 1009 columns. I am trying to insert the data from excel into sql server. However, I am getting error saying The statement has been terminated. (3621); [42000] [...
- 41
0
votes
1
answer
707
views
Dynamically using INSERT for cx_Oracle - Python
I've been looking around so hopefully someone here can assist:
I'm attempting to use cx_Oracle in python to interface with a database; my task is to insert data from an excel file to an empty (but ...
- 161
0
votes
4
answers
333
views
Extracting parameters from strings - SQL Server
I have a table with strings in one column, which are actually storing other SQL Queries written before and stored to be ran at later times. They contain parameters such as '@organisationId' or '@...
- 37
1
vote
1
answer
58
views
Find Column Groups in Data
I have an excel file with Data of users who visited specific screens on an App.
eg.
I need to figure out a way to find multiple screen group users
eg.
The number of unique screens are 6 so manually ...
0
votes
0
answers
29
views
How do i add a column with the crew name according to date_time?
This is the situation:
There is a warehouse that operates 24/7.
It has 3 Crews, working on 2 shifts- Crew 1, 2 and 3.
The Shift System works like this:
7 x 3 - work 7 days and rest 3 days.
7 x 4 - ...
