User Profile
Simon_29
Helper II
Joined 4 years ago
User Widgets
Contributions
Transposing columns
Hello, I need to create something similar to the screenshot below. I have TABLE 1 as a SharePoint list. I need to move the columns with First_Value into rows, because I need to continue working with those values + their data in the Slicer filter as well. However, when I transpose, i.e. unpivot these columns to rows, the values are duplicated. All values are fine when duplicated, but the Hours column takes on a completely different meaning. For example, there are 8 hours for From_To 6-14. However, if I transpose it, there are already more hours, but I cannot work with this number because it makes a different sense. I would probably need an arithmetic mean or some solution to solve this. Can you help me? Thank youDynamic path to the folder with the excel files that I combine together in Power Query
Hello, I can create a dynamic path to a folder and a selected file in Power Query. I can change FileSource and FilePath dynamically. However, this time I load multiple excel files from one folder and combine (append) them together. I would need to create a cell in Excel that would serve as a place where I insert the PATH to the folder and when I refresh the power query, it will automatically load all the files under it as shown in the screenshot below. Can you please help me? Thank you very muchRe: Merge columns based on words contains
Hi 🙂 Thank you very much for your reply. This would be a partial solution, but the point is that redundant words like "and", "of" and similar are deliberately removed in ISSUE_CLEANED. Therefore, it was just some contains function that will say that if there are ISSUE_CLEANED in the Issue (that is, phrases cleaned of redundant words), then find the intersection and assign Issue_Group_Type. Is there any such function/possibility to do it? Fuzzy works but not quite well, for example with Issue: missing order from attainment Could not find link to ISSUE_CLEANED: missing order attainment and did not assign Issue_Group_Type.. however, they do not match in only one word.Merge columns based on words contains
I have one more question. I will give a little more precise data. I created the ISSUE_CLEANED column from the Issue (already without words in the STOP_WORDS column), but now I needed to merge the following using some contains function: To the new table with the Issue column from tables no. 1 in picture no. 1 assign the values from tables no. 2 in picture no. 2 so that if the words from the ISSUE_CLEANED column are in the Issue column, match the Issue_Group_Type column. Could you help me with this? Thank you very muchRe: Deleting the values of one column from the first table based on the values from the second table
Excellent!!! It works! Thank you very much 🙂 I have one more question. I will give a little more precise data. I created the ISSUE_CLEANED column from the Issue (already without words in the STOP_WORDS column), but now I needed to merge the following using some contains function: To the new table with the Issue column from tables no. 1 in picture no. 1 assign the values from tables no. 2 in picture no. 2 so that if the words from the ISSUE_CLEANED column are in the Issue column, match the Issue_Group_Type column. Could you help me with this? Thank you very much 🙂Deleting the values of one column from the first table based on the values from the second table
Hello, let's say we have two tables which are below. The 1st table contains the STOP_WORDS column. The 2nd table contains the column ID, Issue and ISSUE_GROUP_TYPE. The question is: how can he combine Issue and STOP_WORDS so that I have a column ISSUE_GROUP_TYPE. This means that the values contained in the STOP_WORDS column are matched to the Issue column and discard the words from the STOP_WORDS column. Thank you very much for your helpMerging two tables, which, based on matching values, removes the given values
Hello, I have two tables. One contains the Issue column. The second contains the words that I want to match based on the match in the merge. When a match is found, I want to remove those stop words from the Issue column. Can you help me? Thank you very much
