Notifications
Clear all
Topic starter
Hi Guys,
i have table like here:
TableNameColumnName
| Deployments | Topology |
| Deployments | Subscription |
| Deployments | Region |
| Table1 | Col1 |
| Table1 | Col2 |
| Table1 | Col3 |
and want to check if "Topology" Column Exists and get as result this table:
TableNameColumnName
| Deployments | TopologyColumnExist |
| Table1 | Is not present |
How to do this?
In Excel i would use CountIFS to get the result...
Best,
Jacek
Posted : 22/10/2021 5:07 am
Posted : 22/10/2021 6:59 pm
Topic starter
Thank you Alan Sidman for nice explanation about cross posting - i will comply with it ! 🙂
Best,
Jacek
Posted : 23/10/2021 6:53 am
Topic starter
Anyone?
Best,
Jacek
Posted : 26/10/2021 4:53 am
There are several ways you could achieve it. For instance, you could create one query on the table that filters for topology, then merge that query with the original table grouped by tablename. If the result is a null field, then it's missing and you can use a calculated column to return whatever text you like.
Posted : 28/10/2021 9:42 am
Topic starter
Thank you for helping me,
Best,
Jacek
Posted : 28/10/2021 10:12 am
