questions in power query
I have started to use powerquery and absolutely love it..however I have a few questions
1. How do I do a count if for duplicates in a new column
2. How can I do an index match with power query
3. I get new files every week, will all the calculations that I perform on the current query will be applicable to the new file once I change the source file to the same as for the previous query? ex the data source for current query would be "source.txt" and once I receive the new file I replace the "source.txt" with a new file
4.this step is little complicated for me, I receive a text file where every row which starts with "H" I have to be in a separate worksheet, how can I achieve this
1. How do I do a count if for duplicates in a new column
2. How can I do an index match with power query
3. I get new files every week, will all the calculations that I perform on the current query will be applicable to the new file once I change the source file to the same as for the previous query? ex the data source for current query would be "source.txt" and once I receive the new file I replace the "source.txt" with a new file
4.this step is little complicated for me, I receive a text file where every row which starts with "H" I have to be in a separate worksheet, how can I achieve this
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.