Forum Discussion
From Journal description common words idenfication
Hi,
Is there way I can identify the common words across the journal description? Combined both decription and give me some thing coomon that can enable us to do the tax review. Alternatively just using " Journal Line_Dsc that give common key words then I can use that keywords to do the analysis whether it is subject to tax deduction or not?
For e.g
| Journal Line _Dsc | Journal_Dsc | Key word |
| 48 Class FY24 Unsch True up | Loco Asset Cap True Up FY24 Jul to Mar24 | 48 Class Unsch Lco |
| 2000 x SEALBOLT3 Security Bol | Accounts Payable | Sealbolts_Accounts Payable |
| 71 class Cyc Var Jan-24 | UGL QLD 71 BMA Loco Maint Accrual Jan-24 | 71 Class Loco Maint |
3 Replies
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.Sorry , if I wasn't clear. The column Journal_Line Dsc and Journal Dsc is the orignal data, the column Keyword is what I wanted as " expected outcome".
Thanks
From you example I ca't see how you came up with the values in your Keyword column. In several cases words appear in Keyword that are not common to the other 2 columns.
But!
Guessing what you want:
Split by delimeter " " the journal columns .
Do a List.Intersect of the 2 resulting lists.
Do a Text.Combine of the intersect with " " as a delimiter
Or alternatively, Expand the intersect list so you get a row for each keyword. This may be easier to analyse....
