How to check whether a specific column exists in a table, for example, whether the student name exists in the table?

How to check whether a specific column exists in a table, for example, whether the student name exists in the table?

Hello @cghw62382 ,

if you know the exact column name, I would to the following:

  1. Use a Column Name Extractor node to get the column names
  2. Use a Transpose node to get the values in a single column
  3. Use a row filter to select the row

Something like this, but if you need it for something more specific tell me :slight_smile:
Have a nice day,
Raffaello Barri

3 Likes

@cghw62382
You could try Table Validator node
br

4 Likes

@Daniel_Weikert

thanks, Daniel, now I want to replace the NULL value to “0” in the culumn “<=2000kbps+Count(gNodeB Name)”, but it can not work, I have tried Rule Engine Node, but below expression cannot work.
$<=2000kbps+Count(gNodeB Name)$ =“” => “0”

3

thanks Sir Lelloba, Table Validator (Reference) Node is better for my issue.

1 Like

I have solved this issue of NULL value to 0 , add Missing Value Node.

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.