No announcements
Found 2391432 threads
-
6 VotesRemove columns based on columns names in Power Query
Hello, In Power Query, how can I remove columns based on how their names begin? i.e. I ...Answered | 5 Replies | 1815 Views | Created by Tamiri7 - Thursday, October 25, 2018 3:57 AM | Last reply by Tamiri7 - Friday, October 26, 2018 8:14 AM
-
0 Votes
Dynamic remove power query columns
"I would like to keep only the NEXT 6 months of data based on the earliest date in the dataset.. and Filter out all other Month ...Answered | 5 Replies | 617 Views | Created by blytonpereira - Monday, December 31, 2018 9:06 PM | Last reply by Colin Banfield - Tuesday, January 1, 2019 1:28 AM -
1 Votes
Pdf.Tables inconsistant table names and table structure
all columns in 1 column. I add Text.PadEnd(columnx,30) to all columns to be able to split later some columns based on number of ...Discussion | 1 Replies | 341 Views | Created by Dirk Verliefden - Friday, February 14, 2020 2:35 PM | Last reply by GeneQuery2 - Monday, May 18, 2020 5:09 PM -
8 Votes
Reordering Columns in Power Query
Is there an easy way to reorder a lot of columns in Power Query or is dragging and dropping the only way? I have a ...Answered | 6 Replies | 20056 Views | Created by VivDev - Monday, June 22, 2015 10:01 PM | Last reply by jbt_PwrPvt - Friday, December 16, 2016 9:16 PM -
0 Votes
Create calculated columns in power query
Apparently you haven't discovered Power Query yet. Power Query is also known as "Get & Transform Data" in Excel, so yes: adding ...Answered | 1 Replies | 765 Views | Created by Albo44 - Monday, April 17, 2017 8:46 PM | Last reply by MarcelBeug - Tuesday, April 18, 2017 3:37 AM -
1 Votes
Power Query: Stacking 2 columns
Fellow power query users, I have a need to stack emails from two different columns so email 2 goes below email 1. How do I do that in ...Answered | 2 Replies | 2473 Views | Created by NLuu - Thursday, April 18, 2019 3:27 PM | Last reply by NLuu - Thursday, April 18, 2019 8:02 PM -
2 Votes
remove duplicates based on three columns
Hello. How can I remove duplicates where all three columns have the same value in the rows. Thanks.Answered | 2 Replies | 470 Views | Created by AlexMartini - Tuesday, October 25, 2016 1:58 AM | Last reply by Uri Dimant - Wednesday, October 26, 2016 6:45 AM -
3 Votes
OData in Power Query - identify Key columns?
Hi everyone, I am consuming an OData-Feed from Microsoft Dynamics in Power Query. For each feed that I am calling, I need to dynamically identify the ...Answered | 5 Replies | 759 Views | Created by Ju Hansen - Wednesday, July 8, 2015 8:05 PM | Last reply by Greg Deckler (Fusion Alliance) - Friday, July 10, 2015 5:29 PM -
1 Votes
Selection of Columns Dynamically in Power Query
Hi Haider, It depends on your query, but in common case you may use this expression to refer to all your columns (including the new ...Answered | 12 Replies | 552 Views | Created by Haider Alee - Wednesday, March 6, 2019 9:46 AM | Last reply by Haider Alee - Monday, March 11, 2019 4:56 PM -
0 Votes
Update multiple columns based on the columns in another table
Hi, I have around 80 columns that I need to update by using columns in another table.Pls suggest any simple way. What i am using ...Proposed | 2 Replies | 2117 Views | Created by SQL_SAM - Thursday, December 27, 2012 7:43 PM | Last reply by Kalman Toth - Thursday, December 27, 2012 9:31 PM -
1 Votes
Can I reference columns using relative references in Power Query?
I have a use case where I want to remove the last 4 columns in Power Query. Each month I get a new file with a new column, and I want to unpivot the ...Answered | 3 Replies | 2549 Views | Created by Matt Allington - Thursday, March 13, 2014 11:56 PM | Last reply by Curt Hagenlocher - Friday, March 14, 2014 1:54 PM -
0 Votes
Loosing calculated columns and measures in PowerPivot/Power Query
I import from an Excel file via Power Query into the data model. Then adding calculated columns and measures in PowerPivot. Next time I open the workbook, the ...Answered | 1 Replies | 1029 Views | Created by Jan-Eric Ramberg - Saturday, October 17, 2015 8:30 AM | Last reply by ckekiass2012 - Monday, October 26, 2015 1:32 AM -
0 Votes
FIND VALUES Based on Columns in Sql
looking for -- and then a query with the result based on your columns DECLARE @query VARCHAR(8000) DECLARE @subQuery ...Answered | 7 Replies | 574 Views | Created by Satyayadav - Tuesday, January 19, 2016 6:31 AM | Last reply by --CELKO-- - Tuesday, January 19, 2016 5:19 PM -
2 Votes
columns in select query
In SSMS, you can drag&drop the *columns* folder to the query window. It will paste all columns and you can just remove the one(s) you don't want.Tibor ...Answered | 5 Replies | 5035 Views | Created by Sudeep Puvvadi - Friday, August 5, 2011 6:33 AM | Last reply by Kasturi Rajesh - Tuesday, August 9, 2011 6:30 AM -
0 Votes
Select columns based on patterns within the column names
In SQL 2005 is there a way to select columns based on patterns within the column names? For example I have a view with many columns ...Answered | 5 Replies | 5590 Views | Created by Sakendrick - Sunday, August 16, 2009 2:14 PM | Last reply by Sakendrick - Tuesday, August 18, 2009 1:32 PM -
0 Votes
remove columns on view
Hello, I have a problem with Outlook 2016. Only on inbox view when I remove ...Answered | 6 Replies | 1262 Views | Created by tgarijo - Friday, March 17, 2017 9:37 AM | Last reply by Ethan Hua - Thursday, March 23, 2017 2:02 AM -
2 Votes
Power Query and multi-selection columns
Hi Eric, Just to add a bit more detail to what is going. In Power Query, SharePoint List columns ...Answered | 6 Replies | 7633 Views | Created by Eric Alcott - Wednesday, April 23, 2014 6:31 PM | Last reply by Eric Alcott - Tuesday, May 6, 2014 3:41 PM -
0 Votes
Displaying Dynamic Columns based on select columns from dropdownlist
0 ,False,True)Answered | 1 Replies | 1196 Views | Created by Ramakant Singh - Friday, December 5, 2014 3:04 PM | Last reply by SathyanarrayananS - Saturday, December 6, 2014 7:05 AM -
0 Votes
Dynamic Columns Based on Parameters
c.name FROM sys.columns c INNER JOIN sys.tables t ON c.object_id = t.object_id AND t.name = 'myTableName' Now, create a parameter called ...Answered | 2 Replies | 1273 Views | Created by GKFey88 - Friday, August 21, 2015 12:26 PM | Last reply by Patrick Hurst - Friday, August 21, 2015 3:45 PM -
0 Votes
How to show the columns based on the other columns
how to show the columns in the new item page based on the other column?(since the height of new item page is ...Answered | 1 Replies | 7306 Views | Created by Sruthi Dhanda - Friday, March 11, 2011 5:17 AM | Last reply by Dhirendra Yadav - Saturday, March 12, 2011 5:58 AM - Items 1 to 20 of 2391432 Next ›
No announcements
