Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am new to the community, and I really hope you can help me.
I have a column with various organizational units, 15 different units, +8 specific unites per unit and over 1300 people belonging in those specific units.
- ET/UTJ/BMM/TK-TUT/ASSET/T&P/B&J
- ET/UTJ/BMM/TK-TUT/ASSET/T&P/ESNR/BATH
- ET/UTJ/BMM/TK-TUT/ASSET/T&P/WINT
- ET/UTJ/BMM/TK-TUT/ASSET/T&P/E&O/D&WO
The only thing I then want to remain is T&P, so that everything else goes. I already tried to filter the column for all T&P and then extract everything before and after, so that only T&P remains. It works fine, but T&P is only one of 15+ org units and when I do this it seems like I lose all other data in the table except for the one belonging to T&P.
Hi @Anonymous ,
If you filter data with T&P it's obvious that other units will not show up, could you please clarify the need.