jaryszek
Member
Members
Forum Posts: 183
Member Since:
February 1, 2019
February 1, 2019
Offline
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
Alan Sidman
Steamboat Springs, CO
Member
Members
Trusted Members
Trusted Members
Forum Posts: 193
Member Since:
October 18, 2018
October 18, 2018
Offline
crossposted: https://www.excelforum.com/exc.....ost5584892
Velouria
London or thereabouts
Moderator
Members
Trusted Members
Moderators
Trusted Members
Moderators
Forum Posts: 800
Member Since:
November 1, 2018
November 1, 2018
Offline
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.
Answers Post
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Shraddha Sureka, Tracy Xie
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 287
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Kelsey Fennell
Jeffree Bunning
Jackie Memije
John Franzon
Darcie Clayton
trevor mir
Ruby White
Marisa Bradshaw
Eugene Augustine
MacNaughton Finance
Forum Stats:
Groups: 3
Forums: 24
Topics: 6872
Posts: 30122
Member Stats:
Guest Posters: 49
Members: 33668
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —