Hi
I have some problems in translating excel formula into Power Query.
Attached pls find the file - green table is Power Query output data; in column O you can find the proper excel formula - as you can see, there is difference between those two
Bez*tytułu.png
Explain the logic (I am not going to back engineer your long formula to find out - sorry).
More detail, please!
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
hi,
Unfortunately, there is no shortcut. This formula generates abbreviation from a few columns based on some data (in few cases from one letter from a string of letters in one cell). If you open the excel file, you will find out
You didn't understand. I said I will not back engineer your formula to work out the logic behind it.
Please explain here, in FULL detail, what the formula is meant to be doing.
hi,
I hope this will help. pls also find explanantion in the file attached.
Bez*tytułu.png
It looks like you just omitted the test for the second letter being L:
= Table.AddColumn(#"Dodano kolumnę niestandardową1", "Opis beczki", each if [Product Line] <> "Large Steel Drums>=44G/160ltr+" then null else Text.Combine({Text.Combine(List.ReplaceMatchingItems({Text.Start([Item Description],2)},{{"OL","OH"},{"RL","OH"},{"RH","OH"},{"TC","TH"}})),GaugeText([Top Gauge]) & GaugeText([Body Gauge]) & GaugeText([Bottem Gauge]),if Text.Middle([Item Description],1,1) = "L" then "L" else null,if Text.Middle([Item Description],22,1) = "L" then "IC" else null}," "), type text)
Everyone who confuses correlation and causation ends up dead.
thanks @orya
Thanks. See post #5.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks