All Questions
Tagged with excel powerquery
2,810
questions
0
votes
2
answers
43
views
VBA: Editing Power Query M-Code using VBA
I have a shared Excel file with a Power Query that extracts data from an external local file. However, several users work with the shared file and they need the Power Query to access the local file ...
- 1
-1
votes
0
answers
22
views
update delta to static base table [closed]
i have a monthly report, which has a record of all tasks i have at hand on some system i use
every month i get new tasks, but also i finish some tasks
the report is an uptodate report, every month ...
0
votes
5
answers
97
views
Multiple Conditions in Excel considering the table2
I have a data set contains city names.
Table1:
Table2:
I want to apply the Table2 condition .
Exclude USA means "<>USA"
I can do it without considering the Table2 by taking the ...
- 23
-2
votes
1
answer
47
views
Load data in new sheet using existing sheets in Excel using Vlookup or power query
I am working on an excel book which does have two sheets sheet1 and sheet2. This is a large data set consist of more than 20000 records. I could not get this figure out.
Sheet1 columns:
RecordID | ...
- 69
0
votes
1
answer
39
views
Excel Power Query - how to handle error when get data from web
My end goal is to pull 2 data points from internal company url and display it in excel.
end goal
Typically, there are 2 types of "Data_Response_Code" - 200 and 404.
My idea is to first use ...
- 25
0
votes
0
answers
20
views
problem with import text in pdf by power query (right to left language)
if i convert ".pdf" to text & use get data from ".txt" or ".csv" file & set file origin on "1256:Arabic (windows)", then i have a correct text in PQ.
...
0
votes
1
answer
18
views
Power Query: Error on dynamic file path for txt file
I wanted to develop dynamic file path for txt file but it keeps giving me error on the "filecontents" step below:
let
Source = Excel.CurrentWorkbook(){[Name="FolderPath"]}[...
- 1
1
vote
3
answers
40
views
How to identify slabs based on a config table in SQL or excel
I have 2 tables, a Transaction table and Config table.
Based on the percentage achieved, I need to identify slab and rating from the config table.
Config table values can undergo changes including ...
- 1,323
0
votes
5
answers
57
views
How to transpose subset of columns into rows and group by remainder of rows? Excel? SQL?
We are in the early stages of migrating some data from a legacy system to a new system that seems to have some quirks.
Currently we have some data that is as follows
Name Date Award
Roger ...
- 165
0
votes
1
answer
60
views
Append incrementing value to some cells with power query
So I'm receiving an Excel file with RefID information provided for TypeA users. This table is named and is on Sheet1
UserType
Login
RefID
TypeA
aaa
9991
TypeA
bbb
9992
TypeB
ccc
TypeA
ddd
9993
...
- 11
2
votes
2
answers
73
views
[Excel][Power Query] Reducing list of shipped goods by returned considering "first out first in"
My company is shipping some parts to external paintshops. There is a number of paintshops and many part numbers.
I have a list with history of every move (shipped and returned).
My goal is to process ...
- 45
0
votes
1
answer
45
views
Use Power Query to consolidate rows (like Pivot Table, but maybe something else)
(Very simplified) I have data like this that I get after a complex series of steps in Power Query.
Previously, I used a Macro to create a Pivot table like so:
But I was hoping to get away from that. ...
- 39
0
votes
0
answers
23
views
Excel data copy with multiple filters in pivot table to another excel
I have an excel which has inputs to be entered in multiple sheets after which a pivot table in one of the sheets is to refreshed with filters as per the needs. This then updates another table which ...
- 1
1
vote
2
answers
43
views
Extract JSON Array to same Row using Excel Power Query
I have the following JSON
{
"Data": {
"totalExecutionTime": "00:00:00.5544916",
"totalCount": "33414",
"Items": [...
- 3,547
1
vote
1
answer
30
views
Partial Power Query transposition so that captions remain
Novice power query user here. I would greatly appreciate if someone could help me with the following problem. I'm tasked with modifying an excel template that is roughly of that format:
City
Borough
...
- 15