
jaryszek
Member
Members

Forum Posts: 183
Member Since:
February 1, 2019
February 1, 2019

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: 132
Member Since:
October 18, 2018
October 18, 2018

crossposted: https://www.excelforum.com/exc.....ost5584892

Velouria
London or thereabouts
Moderator
Members

Trusted Members
Moderators

Trusted Members
Moderators

Forum Posts: 615
Member Since:
November 1, 2018
November 1, 2018

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: Mynda Treacy, Shanna Henseler, Stacy Culpepper
Guest(s) 11
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
John Chisholm
vexokeb sdfg
John Jack
Malcolm Toy
Ray-Yu Yang
George Shihadeh
Naomi Rumble
Uwe von Gostomski
Jonathan Jones
drsven
Forum Stats:
Groups: 3
Forums: 24
Topics: 6212
Posts: 27237
Member Stats:
Guest Posters: 49
Members: 31889
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
