Skip to main content
  • EN

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!

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

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

30,176
Posts
114,541
Replies
37,835
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.