All Questions
263
questions
-2
votes
1
answer
60
views
Extract only phone number without country code in BigQuery
I have some data in GCP BigQuery where the 'phone_number' column is in the formats shown below. How can I extract only the digits in the data corresponding to the area code and subsequent phone number,...
- 5,560
0
votes
1
answer
37
views
Set value in column based on multiple conditions on multiple columns
Could someone please help me on this.
Been searching for hours on several platforms, tried several solutions but can't figure out the exact code for the possible solutions. In other words: I can't get ...
- 35
0
votes
2
answers
64
views
Preferred Product Analysis using DB2 SQL
I have Data which looks like this:
ID
SERVICE_TYPE
CNT
12345678
SACCOS
0
12345678
RETAIL_SME
0
12345678
TRANS_LOGISTIC
0
12345678
HEALTHCARE
0
12345678
ENERGY
7
12345678
NGO
0
12345678
...
- 29
0
votes
0
answers
16
views
How to compare an audit file with the attribute in nifi
I have an audit file like :
Abc,123
Code,234
where the first column is the filename and second column is the record count of the file.
Now I have 2 such flow files with its filename and respective ...
0
votes
1
answer
140
views
DML operation should not be allowed while reading SQL query from .txt file
My SQL query is stored in a .txt file, and with the help of C#, I'm reading that query and fetching data from the database.
I want to make sure no DML operation should be performed. How to achieve ...
- 19
0
votes
0
answers
23
views
SQL to TRANSPOSE / PIVOT data from rows to columns for multiple rows of text per ID
I want to provide a list of approver names in different columns by approval level, there are multiple approvers per cost centre - for this one cost centre the result should have 4 rows, as there are ...
1
vote
1
answer
32
views
Is it possible to use Text for SQL Indexing
I got the following error:
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1170 BLOB/TEXT column 'summary' used in key specification without a key length in c:\website\someclass.php
...
- 33
0
votes
1
answer
67
views
How to create a new column in SQL based on information in a column?
I am trying to search message codes within 1 table and think it would be easier if I create a new column that specifies each code within the column with the corresponding formula.
So I am trying to ...
- 129
0
votes
2
answers
75
views
SQL - Filter and group based on column value
I have the below table.
Code Status
1 Noaudit/One
1 Audit/One
1 Audit/Two
2 Noaudit/One
2 Noaudit/Two
3 Audit/One
3 Audit/Two
...
- 1
0
votes
3
answers
136
views
Remove everithing that it outside the brackets
I need your help.
I working with Oracle SQL and I need to remove everything that it outside the brackets.
For example:
- Stabilization loans, mortgage lending (StabL ML) => StabL ML
- Refinanced ...
- 21
0
votes
1
answer
32
views
Database type to organize text fragments
What kind of database (or any other tool) would you recommend me to organize text fragments (typically entries in a journal), probably with images attached to them, and retrieve texts according to ...
-1
votes
1
answer
40
views
from text to new row
I have text:
[{crmId: 270294251239318446711736, zapłacone faktury:0}, {crmId: 109338771587264730348439, zapłacone faktury:0}, {crmId: 105563037561893625234667, zapłacone faktury:0}, {crmId: ...
-2
votes
4
answers
78
views
What is the best way to split a column of data in a txt file based on the first delimiter? [closed]
I have a large number of txt files with a single column of data. There are no headers in the files.
The data are an email address followed by a : and then a string of varchar, which sometimes includes ...
-1
votes
2
answers
440
views
SQL sum numbers in text
This is the code
select 'QWXWX/50,GNTGHNT/5,F/500'
I want to see sum of the numbers in this texts. My expectation result is 555.
- 55
0
votes
2
answers
3k
views
SQL replace zero 0 values with NULL or text
I have a table Products
Some ProductPrice values are 0 (type is decimal(10,0))
ID | Productname | ProductPrice |
+----+-------------+--------------------------------------+
| ...
- 43