Questions tagged [customcolumn]

54 questions
0
votes
1 answer

Compare columns return maximum power query

I have data from multiple suppliers which I wish to compare. The data shown in the image below has been previously transformed via a series of steps using power query. The final step was to pivot the Supplier column (in this example consisting of…
Nick
  • 789
  • 5
  • 22
0
votes
1 answer

Wordpress media library missing entries with NULL value when sorted after custom column

i have included 2 custom columns in the metadata of media entries called 'photographer' and 'copyright'. I have included both columns in the admin view of the media library and made them sortable. But when i sort by one of them the results exclude…
a.urbanite
  • 75
  • 7
0
votes
1 answer

How to add custom column for previous day sales for each product in Power Query

I have this table: Date Product Sales 1/3/2021 Apple 10 1/3/2021 Lemon 20 1/3/2021 Mango 30 1/4/2021 Apple 15 1/4/2021 Lemon 25 1/5/2021 Apple 20 1/5/2021 Lemon 20 1/5/2021 Mango 35 And I want to add a new column like…
dss333
  • 71
  • 1
  • 2
  • 7
0
votes
1 answer

Making custom column in WordPress dashboard for custom taxonomy SORTABLE

I'm tearing my hair out trying to figure out what's wrong with this code. I've already read and tried every single question on this topic on StackOverflow - I'm hoping someone can spot a small bug and figure it out. I have a custom post type called…
turtlehead
  • 11
  • 3
0
votes
1 answer

custom column and calculated column

i am trying to create a custom column using Mon-Year_period = FORMAT(trial[Date],"MMM-YYYY"). It gets accepted when write for custom column but when I close and apply the same, says FORMAT function error. Also, when tried the same for calculated…
0
votes
1 answer

Answer: Laravel 7, select dynamic columns in query builder

I have spent a lot of my time to find this solution. I want to export a user selected list of columns data and here is the solution for this. The solution is getting a list of columns in array form and then I am converting it into a specific…
M Atique Khan
  • 18
  • 1
  • 5
0
votes
3 answers

Power Query Statements for New and Repeated Order (Custom Column)

I have a Sales table consists of Date, Customer and Product columns. I want to segregate the data into two parts, New and Renew order. Each customer can order many types of products and each new product ordered by the customer will be state as New…
0
votes
1 answer

Power Query - complicated custom column

I need to create a custom column which looks at 1 column, a, and based on a, trims a value from b and puts the value in c. Part B: Now if the value in a does not match my criteria, then it looks at column d to find if it was the same as the…
Rp2019
  • 1
  • 2
0
votes
1 answer

Power Query: M Code for adding days (as column reference) to date

Power Query: Table:'TableABC', with columns: [Todays Date],[Additional Days]. I want to create M Code to add [Todays Date] + [Additional Days]. I keep getting an error, because [Additional Days] is a decimal number- I think. Do I need some logic to…
0
votes
1 answer

RoRails~5: associations with custom db-field names

This question was discussed numerous times, however I run into an issue that I could not find an answer to. I am building a login system where one Member(:class) "bails for" a new Member. Internally, they are referenced as "member" and "candidate"…
randmin
  • 818
  • 8
  • 16
0
votes
1 answer

can we create Azure custom date column?

We have Azure AD that migrated from Windows AD we need custom attribute(Column) in user profile as Date, such as Hire Date is this possible? Any suggestion is appreciable See Image
0
votes
1 answer

sharepoint: how to register eventhandlers on creation of column from Site column

I am creating a custom column type in SharePoint. This custom column requires some event handlers (like itemAdding etc.) to be registered with the list which is using this column. Now user can also create a site column of this custom column type.…
0
votes
1 answer

Creating custom column type

I'm creating custom column type, and i was able to implement it on my test site. I want to learn how to add some settings/properties/configurations to this column type (sorry I'm not sure what it is exactly called for reference attaching image…
0
votes
1 answer

Wordpress - marge – post type + custom post type + custom column in posts list

I have created one custom post type with taxonomy and it works fine. I am going to show custom post type content in default posts list with help of “pre_get_posts” hooks and it displayed in posts list. I need to show custom column name as “post…
0
votes
1 answer

list all the data, merge duplicate rows and sum the total using MySQL

I have the following SQL SELECT i.si_num AS `id`, DATE_FORMAT(i.si_date, '%d-%b-%Y') AS `date`, i.si_tr AS `tr`, d.dl_name AS `customer`, i.si_net_value AS `net`, DATEDIFF(CURDATE(), si_date) AS Days, t.value AS tval, t.label AS…
Prem
  • 31
  • 8