How To Segregate Data Out Of Database And Create New Things?

Not sure how the best approach for this is.

I’m trying to use existing data in the following format:

Name1
Name1
Name1
Name2
Name2
Name3
Name3
etc.

And create a new THING for only ONE of each of the names (as the example above)…

Any help appreciated!

Bump on this one…

Anyone have any insight in how to set this up?

Run an API workflow on the duplicated list of things, then add :unique to the list. The API workflow will create the thing.

Yeah I thought that, but what do I search against?

Name1
Name1
Name1
Name2
Name2
Name3
Name3

By use of the scheduled api workflow it should create a different Thing for each single-instance ‘Named’ Thing above, so the above list would become:

Thing 2, Name 1
Thing 2, Name 2
Thing 2, Name 3

And so on, without duplicates.

1 Like

Anyone have any guidance on this one?

@NigelG (or anyone really) any chance you could clarify this one?

This one is a sticky issue for me. I think it may be able to be done by using the Grouped By function, but I can’t get the issue checker to clear when I’m grouping them by “name:uniqueelements:” the unique elements won’t work.

I also tried this:

Bump… still stuck.

Do as @NigelG suggested. In your api workflow use a Create a new thing and the type should be your Thing2. The name should be aircraft name (the api workflow parameter)

1 Like

Hi @JustinC,

Were you able to sort this out ?

Even I have same requirement. Can you please suggest me how ?

Thanks.

This topic was automatically closed after 70 days. New replies are no longer allowed.