Question

How to check a list (array) of data is within the given table (excel)

  • 22 November 2021
  • 2 replies
  • 2 views
Z
Badge

Hello there,

​

So I have a list of data - Floor and units. For the units, it could have more than one categories (with space to seperate different categories). And I have a excel list that shows all the categories.

What I can ​to do is to check all the Units are within the excel table categories. Might I ask how to do it? Since there could be several cateogries in one unit, I am not sure how what transformer I should use to solve my problem.

 

Data:

Floor Units

G/F Lobby

1/F Office Toliet

 

Excel:

Type

Lobby

Office

Toliet

Bathroom

 

Thank you for your help!

2 replies

geomancer
Rank
Userlevel 4
Badge +36

As the Data features can contain more than one category, split them into features with an AttributeSplitter and a ListExploder (use 'Units' as List name to reuse the Units attribute).

Next use a FeatureJoiner to compare the Units and the Types.

Verify_Units

Z
Badge

As the Data features can contain more than one category, split them into features with an AttributeSplitter and a ListExploder (use 'Units' as List name to reuse the Units attribute).

Next use a FeatureJoiner to compare the Units and the Types.

Verify_Units

thank you for the through answer. I will definately try it! Again, thank you so much! :)

Reply


Community Stats

28,731
Posts
109,527
Replies
36,565
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.